Union Query (choosing between two fields)

[naveehgreen]

I'm trying to combine a few queries with a union query and was wondering if something like this scenario is possible to code:

Basically, there is an ID field (column 1) that I've already put in place and then I have two fields of values to choose from (Field A and Field B) so that I will end up with two columns in total. If Field A = 0, I'd like the query to take the value from Field B and multiply it by -1 and have that be the value in column 2. If there is already a value besides 0 in Field A, I'd like the query to take that value.

Also, if the ID field is blank or is labeled 'Excluded,' I'd like the query to leave those rows out.

Any help you can provide would be great.

Thank you.

[pbaldy]

You can use an IIf():

IIf(FieldA = 0, FieldB * -1, FieldA)

You can add a WHERE clause to exclude records.