Multiple if then statements in query

[denileigh]

Hi all,

I have a query that I just can't figure out. We are a facility that works on rail cars. We have over 200 cars in house at the moment and the database has a daily production report in it with the status of all of the cars.

I need a query that will pull out the "AAAA" and "XXXX" cars from the list only IF the cleaning field or the mechanical inspection or BOTH fields are blank.

I can't seem to figure it out. Any help is appreciated!

 

[plog]

What have you tried exactly?

Here's a link to the IIF function (http://www.techonthenet.com/access/functions/advanced/iif.php)

 

[denileigh]

I've tried a ton - including giving them values and calculating them. I'll go play with some of those ideas. I think part of my issue is the if A is blank or if B is blank or if both A and B are blank. That last part has me stumped.

 

[plog]

Who cares if they are both blank? You only care if A is blank or if B is blank. Nothing special happens if they are both blank.

If A is Blank -> X
If B is Blank -> X
If A&B are Blank -> X

 

[denileigh]

Plog - I need it to pull those cars in all three scenarios (A blank, B blank or both A&B blank) Will that if then work for that?

 

[jdraw]

Please post a copy of your relationships window.
We need to see your tables and how they are related to get some idea of your database structure.

Also, it would help if you posted a copy of the SQL of the query involved.

 

[plog]

Plog - I need it to pull those cars in all three scenarios (A blank, B blank or both A&B blank) Will that if then work for that?

Logically, you only have to test for 2 things: If A is blank or if B is blank. Nothing special happens if A and B are blank.