Selecting data

[justinhollenbach]

I need to select certain entries of an attribut table that: Where sample Type equals ???AC???, do not include samples where Exc Status equals ???excavated???. Do I have to use some sort of VB Code to do this or can I simply write a definition query of some sorts and select these entries.

[RDHarles]

You should be able to do a query.
Here's how I'd write it in python:

"TYPE = 'AC' AND ExcStatus != 'excavated'"