Access 2003 Report using Query

[CaliGirl]

I built a simple four field database. I need to produce a report that excludes records which contain "Helpdesk", "Open" or "TEST" in the FirstName field.
I built a query which excluded those records. Then I built a report using the query, but the report does not exclude those records. I do not know what I am doing wrong. Can you please help me?

 

[BBQ Kittens]

for your query, for FirstName under criteria... type this <> "Helpdesk" then below that in or: type <> "Open" and below that type <>"Test"...this is saying to the query to display records in that field not equal to those three criteria

 

[vbaInet]

Or use:

NOT IN ('Helpdesk','Open','Test')

... under the criteria of the FirstName field.

 

[CaliGirl]

Thank you so much! I now have a report showing only the records I want to see, however, the firstname field is sorting in descending alpha order, instead of ascending, as it is in the query. Any suggestions?

 

[CaliGirl]

Never mind, I found what I needed. Thank you again for all of your help!!

 

[vbaInet]

Glad we could help!