Hi
I see a symbol " " in a Access Database Queries field, what does it mean?
What kind of condition?
Thanks,
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]