funkykayli
Board Regular
- Joined
- Apr 25, 2007
- Messages
- 183
I have a query where I want to add some columns using an expression. The expression will be based on three other columns in the query. I am trying to accomplish this:
If PY = "2004" AND COVG = "WC" THEN new field = 250,000
I am not sure how to accomplish this. I tried using the expression builder but I am still stuck. Please help!?!?!
If PY = "2004" AND COVG = "WC" THEN new field = 250,000
I am not sure how to accomplish this. I tried using the expression builder but I am still stuck. Please help!?!?!