I would like to to display on a report all part types except those that begin with SR*****.
The report pulls data from a query.

There are many part types to list, so its not logical to list all to eliminate just one.

Not Like "SR*" in the criteria section of the relevant field in the reports underlying query should do it.

Thank You Rich. It works great, I had forgotten about the "not".

When you want to eliminate "SR*" using Rich's solution, it will also eliminate "Sr*", "sR*" and "sr*".

If you only want to eliminate "SR*", perhaps it's better to use this:

WHERE Mid(Player.Player,1,1) & Mid(Player.Player,2,2) NOT LIKE "ST"

Unfortunaly, Access doesn't come with the UPPER function like in ANSI SQL.

Greetings,

RV