I need to write a query that I think is an IF Then statement. Basically I have two fields. If one field contains a specific entry and the second field has a specific entry that was selcted in the first field I want to exclude the entries from the sencond field. This is what I have been told Where sample Type equals "AC", do not include samples where Exc Status equals "excavated". Do I have to make a new field or can I simply write a query for this.
Mapping Center Answer:
You would need to create a new field and then calculate values in the new field based on your if/else condition. Here are links to some examples of python and vbscipt code.
If you would like to post a comment, please login.