calculated controls

[Guest]

I'm a student. I am creating a query that for illistration purposes wants to
merge the LastName and FirstName fields in a query. The query is based on a
table. This demo is suppose to shol calculated fields. when I enter

Name: [LastName] & ", " & [FirstName]

I get an error message that says invalid syntax. You may have to enter an
operand without an operator. I

 

[gls858]

I'm a student. I am creating a query that for illistration purposes wants to
merge the LastName and FirstName fields in a query. The query is based on a
table. This demo is suppose to shol calculated fields. when I enter

Name: [LastName] & ", " & [FirstName]

I get an error message that says invalid syntax. You may have to enter an
operand without an operator. I

Very close try this ([LName] & ", " & [FName])
notice the parentheses.

gls858

 

[gls858]

I'm a student. I am creating a query that for illistration purposes
wants to merge the LastName and FirstName fields in a query. The
query is based on a table. This demo is suppose to shol calculated
fields. when I enter
Name: [LastName] & ", " & [FirstName]

I get an error message that says invalid syntax. You may have to
enter an operand without an operator. I

Very close try this ([LName] & ", " & [FName])
notice the parentheses.

gls858

oops I changed the field names to match mine.
You should use FirstName LastName.

gls858

 

[David F Cox]

Name is an Access reserved word. (they've taken all of the best ones.)

I'm a student. I am creating a query that for illistration purposes
wants to merge the LastName and FirstName fields in a query. The query
is based on a table. This demo is suppose to shol calculated fields.
when I enter Name: [LastName] & ", " & [FirstName]

I get an error message that says invalid syntax. You may have to enter
an operand without an operator. I

Very close try this ([LName] & ", " & [FName])
notice the parentheses.

gls858

 

[Van T. Dinh]

I may be wrong but IIRC, I don't think "Name" is a reserved word in JET SQL
....

 

[gls858]

Name is an Access reserved word. (they've taken all of the best ones.)

I'm a student. I am creating a query that for illistration purposes
wants to merge the LastName and FirstName fields in a query. The query
is based on a table. This demo is suppose to shol calculated fields.
when I enter Name: [LastName] & ", " & [FirstName]

I get an error message that says invalid syntax. You may have to enter
an operand without an operator. I

Very close try this ([LName] & ", " & [FName])
notice the parentheses.

gls858

I didn't use Name nor did the OP I used FName and the OP used FirstName
so even if Name was reserved it wouldn't apply in either case.

gls858