Can you filter a query to hide a field according to value?

[JustMaybe]

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

 

[ColinEssex]

Hi Sarah

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

Col

 

[JustMaybe]

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.

 

[Rich]

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