Crosstab Query assistance needed -- "Where" statement help 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. How do I have the crosstab query exclude those records just from that project and not the others?

Thanks for the lift!
MCC

 

[dhookom]

I'm not sure why this would be any different than filtering a standard query. I expect you could add a where clause of:

WHERE [ToolNameField] NOT LIKE "*S"

Duane
Hook'D on Access
MS Access MVP

 

[MyaCCt]

That will filter all the projects that have tasks with an S, right? In two of the three projects, I need to include the S tasks in the query and exclude them from the third project. Maybe I'm asking too much. Am I better off doing this in two separate queries?

Thanks!

 

[Andrzejek]

If you show us a sample of your data, and the output you expect, that would make it a lot easier to help you.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.