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?
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?