Makeing a query to exclude event types

[Rhids]

Hi,

I'm trying to make a simple query that will exclude a certain record set from a table. I have an events table that logs various types of data from stock movments to QA data. Each record type is identified by a 2 letter code.

Ie if it's a QA record there createing then in the event type they would choose "QA" as the record type. Theres about 15 differant record types and now I'm trying to exclude certain types from being seen by a customer. And I'm wondering how to do it >.<

What I've done so far is chosen all the required fields from the table for the query and under events type I was hoping to say "Exclude this event type".

I'm new to access and so far havn't ventured into Code at all to be honest and not exactly sure this is the best way to do it

 

[ColinEssex]

sounds to me like you need just a parameter prompt box to appear when the query is run.

In the conditions of the field in the query grid put this:

[Enter Record Type]

then run the query, it'll prompt you for an entry, type in QA and you'll get all the QA's

Col

 

[Rhids]

How could I do that in reverse ?
ie I want to show all except the QA type

 

[ColinEssex]

Oh right - instead of the prompt business put this:

<> "QA"

Col

 

[Rhids]

That works great Thanks Col.

"Mismatch in datatype" was coming up, I'd made a mistake and the datatype on one was text the other number >.<

Now using both of those I can create many more happily

Thanks again