Okay...

I have a query to display relevant data for a user..i am displaying a field called 'product'. The problem is that i do want all of these products displayed...apart from one!

Is there a way i can filter the query so that it will hide a field if the value is a variable i have specified????

Thanks S

Hi Sarah

Its not as simple as always being the same product each time is it?

Col
:cool:

the data that i'm trying to hide from the user will be a choice of about three products.

I have just never filtered a query before.

eg. Not "SomeText" or <> 5 etc., on the criteria line for the relevant field