adding two fields on a query grid

Jon123

Registered User.
Local time
Today, 00:52
Joined
Aug 29, 2003
Messages
668
trying to add 2 fields

=[field1] + [field2]

works but I want a space between the 2

how do you do that?

jon
 
The + is an arithmetic operator that is used to add two numbers but it will concatenate them instead if one or both of the arguments is a string. The preferred concatenation operator is &. But, do look both up in help so that you will know when it is appropriate to use the +.

=[field1] & " " & [field2]

Just looking at the code
=[field1] + [field2]
I would assume that you were adding the two fields rather than concatenating them.
 

Users who are viewing this thread

Back
Top Bottom