Report Filter

I have an address label report based on a query of names and addresses. I
want to supress printing labels for those people with emails held in Fieild
MemEMail

so in the Filter property I put Len(Nz(MemEMail)) = 0 no
quotation marks
and the FilterOn is set to Yes

When I run the report it asks for a parameter of MemEMail - why?
Whatever I seem to do, it is ignoring whether there is an Email address or
not - prints all the labels anyway.

I know I am being thick but what am I missing.
Access 2000

TIA

Phil



.

Relevant Pages

  • Re: creating a label report in access
    ... > skip printing on certain labels. ... > it to start printing on the third label. ... Then add a Report Header to your label report. ... Private Sub Detail_Print ...
    (microsoft.public.access.reports)
  • Re: gmail
    ... There are a few big pluses to gmail in my opinion. ... There's also the ability to search your emails like you'd search the ... And labels - that's a big plus for me. ... >>> Dani ...
    (sci.med.transcription)
  • Re: gmail
    ... If 2500 MB would sure eliminate any problems of sending and receiving files that are too big. ... When I received the emails, I labeled them "addresses", and there on the side is a list of my labels. ... I don't know why they're still going with invitations anymore when they're giving out so many of them. ...
    (sci.med.transcription)
  • Re: creating a label report in access
    ... that worked for skipping labels...any suggestions on printing ... >> should use in order to create duplicate, same page labels and also how to ... > Then add a Report Header to your label report. ... > Private Sub Detail_Print ...
    (microsoft.public.access.reports)
  • Re: Printing in Access
    ... Create a union query that repeats the union 5 times and use it as the basis ... for your label report: ... "Pam Besteder" wrote in message ... > I created a report to print labels for mailing. ...
    (microsoft.public.access.reports)