"不是有效名称。确保它不包含无效字符或标点符号，并且不会太长。怎么了？ [英] " Is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?

问题描述

嗨！访问时出现以下错误。从我可以告诉查询中的其他公式，这应该工作。



不是有效名称。请确保它不包含无效字符或标点符号，并且不会太长。有什么问题？



我使用现有字段的模板将这个放在一起。我正在寻找它成为一个电子邮件地址。



用户名：[左（staff.FirstName，20）&（。）& Left（staff.LastName，20）&（@ valleycentralschools.org）]



我尝试过：



用户名：[左（staff.FirstName，20） &（。）& Left（staff.LastName，20）&（@ valleycentralschools.org）]

Hi! I'm getting the following error with access. From what I could tell with the other formulas in the query, this should work.

" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?

I used the template of an existing field to put this one together. I'm looking for it to become an email address.

User Name: [Left(staff.FirstName,20)& (".")&Left(staff.LastName,20)&("@valleycentralschools.org")]

What I have tried:

User Name: [Left(staff.FirstName,20)&(".")&Left(staff.LastName,20)&("@valleycentralschools.org")]

推荐答案

不是有效的name表示你的列名无效，而不是你想要输入的数据。

空格在列名中无效，除非你用方括号括起来

即 [用户名]

最好完全避免空格

例如 UserName

"is not a valid name" means that your column name is invalid, not the data you are trying to put into it.
Spaces are not valid in column names unless you surround them with square brackets
i.e. [User Name]
Better would be to avoid spaces altogether
e.g. UserName

找到解决方案。公式应该相等：左（[staff.FirstName]，20）&（。）&Left（[staff.LastName]，20）&（@ valleycentralschools.org）



我的括号不正确。感谢所有看过的人。

Solution Found. Formula should equal: Left([staff.FirstName],20)& (".")&Left([staff.LastName],20)&("@valleycentralschools.org")

I just had incorrect brackets. Thanks for all who looked.

这篇关于"不是有效名称。确保它不包含无效字符或标点符号，并且不会太长。怎么了？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！