symbol " "

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

Guest

Hi
I see a symbol " " in a Access Database Queries field, what does it mean?
What kind of condition?
Thanks,
 
Hi
I see a symbol " " in a Access Database Queries field, what does it mean?
What kind of condition?
Thanks,
Click to expand...

It means a literal space character.

Just for example, suppose you have fields FirstName and LastName
containing (say) "John" and "Vinson".

If you create a calculated field for display purposes by concatenating
those two fields

FullName: [FirstName] & [LastName]

you'll get a hard to read result JohnVinson.

If you use a literal string between them

FullName: [FirstName] & " " & [LastName]

you'll get a more readable "John Vinson".

John W. Vinson[MVP]
 
Back
Top