Re: Report Filter

On Mar 30, 6:35 am, "Phil Stanton" <p...@xxxxxxxxxxxxxxxxxxx> wrote:
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


Hmm, I tried that, and it worked for me.
I don't believe your filter query is the problem.

.