Set Criteria to Show 'W' if exists otherwise..

[nwgrl]

I have created a query/report that meets all necessary criteria except that it contains multiple TYPEs per employee. This isn’t an issue unless one of the TYPEs is ‘W’.
As TYPE ‘W’ supersedes all other TYPEs, any others that meet the other criteria should no longer be reflected in the query/report.

Is it possible to add criteria for this?

 

[Matt Greatorex]

What does the current query look like?

 

[nwgrl]

It's pretty basic. It pulls data from four tables.
The only criteria that I am using in the query is for an End Date field to pull 'Between CDate(Now()-1) And CDate(Now()+13)' and a Status field to pull only 'Approved'.
I was grouping by Type but that then I found that running a query for Type 'A' would not give me the results I wanted as Employee 123 would report under 'A' as well as 'W'. Users would then have to run two reports to compare the data which I'd like to avoid.

 

[KeithG]

Yes I am sure you can do that. There are actually probably several ways this can be accomplished. How good are your SQL skills? Do you know about sub-queries and Union queries?

 

[nwgrl]

Skills??? Excperience?? I have minimal of both when it comes to Access. I've only just started working with it in any in depth fashion.
Are there some examples somewhere I can take a look at?? I've learned what little I know by looking at Help, others' work, or examples.
Any guidance is greatly appreciated!!