Ask A Cartographer

VB Code

August 30 2011 | 0 comments
Categories: Map Data

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.

Contact Us | Legal | Privacy |