How can I combe fields in a query when 1 fields is empty?

WalterInOz

Registered User.
Local time
Tomorrow, 08:08
Joined
Apr 11, 2006
Messages
93
I'm combining 4 fields in a query but am running into trouble when 1 of the fields contains no data, which is sometimes correct. The result is that the field displaying the outcome of the combine query is empty, which is not what i wanted to achieve.
Here's how I currently combine 3 fields:

Journalinfo: [Journal]+", Vol. "+[Volume]+", "+[Pages]

Sometimes I need to keep Volume and pages empty and I end oup with an empty field in the form.

Is it at all possible to use an empty field in a combined query?
Any tips?
 
You can use the fact that the + concatenation operator propagates Nulls,while the & operator does not.
 
Thank you Paul, replacing + by & does the job. GREAT
 

Users who are viewing this thread

Back
Top Bottom