Hi,
Up to this point i have used more VBA then exploring the power of queries,
but I could really use some help with something that I think is possible but can not figure out.
If I have a query that has 2 fields, and i want to make one field = 0 if the other field is true, how do i go about writing that expression?
Would someone please give me a simple example (and syntax) that i can apply to my database based on what i have explained?
Thanks for your help,
Brian
Up to this point i have used more VBA then exploring the power of queries,
but I could really use some help with something that I think is possible but can not figure out.
If I have a query that has 2 fields, and i want to make one field = 0 if the other field is true, how do i go about writing that expression?
Would someone please give me a simple example (and syntax) that i can apply to my database based on what i have explained?
Thanks for your help,
Brian