really simple one

[RDM]

this might be a crude roundabout way of doing things
but it works as is, and i'm trying to streamline a little.

i have a database that contains all of my customer's details.
once a month remove those whom no longer want my mailout,
and export the remainder into excel so that my printer can print and stuff envelopes.

i record customers that no longer wish to recieve my mailout, by putting something(anything) in a column that says rts.

what i'm trying to work out is, how in a simple query i can prevent any record that has any value in the rts column from displaying the name/address etc.

if there's a code to say

if anything in rts exists then hide name address state postcode

 

[pbaldy]

Try a criteria of

Is Null

 

[RDM]

thankyou very much! - i did say it was a simple one!