G
Guest
If I create a query field such as this...
NewField: [Field1] & " " & [Field2]
then NewField will have a leading blank space for each record with a null
value in Field1.
How do you clear the space?
(I think I have seen once before a function that does this, but I have
searched Help under all the key words I can think of, and can not track it
down again.)
NewField: [Field1] & " " & [Field2]
then NewField will have a leading blank space for each record with a null
value in Field1.
How do you clear the space?
(I think I have seen once before a function that does this, but I have
searched Help under all the key words I can think of, and can not track it
down again.)