Query in crosstab; extra filter layer needed

[MyaCCT]

Good morning everyone,

Question: I have a crosstab query that tells me the count of tools by project. For one of the projects, I need to exclude tools that have an S after their name, but not on the other projects. :banghead: How do I have the crosstab query exclude those records just from that project and not the others?

Thanks for the lift!
MCC

 

[namliam]

That sounds like a fairly simple and straight forward "OR" clause?
( Project = "X" and Tools not like "*S" )
or
( Project <> "X")

 

[gblack]

You could simply create a preliminary query with all the filters you want (i.e. dataset you're looking for)... then create your crosstab using said query as the base (vs. using a table directly)....no? Or if your crosstab is based on a query already... just filter your base query.