calculated controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Pat said:
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
Click to expand...

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

gls858
 
gls858 said:
Pat said:
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
Click to expand...

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

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

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


gls858 said:
Pat said:
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
Click to expand...

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

gls858
Click to expand...
 
David said:
Name is an Access reserved word. (they've taken all of the best ones.)


gls858 said:
Pat said:
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
Click to expand...
Very close try this ([LName] & ", " & [FName])
notice the parentheses.

gls858
Click to expand...
Click to expand...
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
 
Back
Top