Do not print blank fields

Graham Bucknall

Registered User.
Local time
Today, 23:39
Joined
Feb 28, 2002
Messages
28
I have some reports that gather address data from a query. Some fieldds are blank (eg add4 and add5). How can I set up the report so that it doesn't leave blank line where there are blank fields?
 
That's fine but I'm not sure I understand the syntax and am not sure about your CHR(13) etc.
If I have field add1, add2, add3,add4, city,zip where 2,3 and 4 are frequently blank, how would I produce the concatenation? Also, would this be in the query?
 
Yes, IMO it's a MUCH better way.

Had the same problem Grham had many years ago then discovered the article I posted in the A97 KB.

Used it ever since.

Mainly use it for labels/
 

Users who are viewing this thread

Back
Top Bottom