query is null then field

[eric.l.bohon]

Good Morning to all,

Need help on a expression in a query.

I need to be able to get in a query if one field from a query is blank and the filed from a table is filled in then it shows the one that is filled.

here is the expression that I am using:

sum(IIf([qryTravel].[field] is null,([tblMonth].[field])))

the tblmonth has all the months in it with 0.00 dollars in it. when i have that query open it shows all the months with the data in it. but when i go in and put someones travel in then the data disappears.

Any help

 

[Joe4]

Take a look at the syntax of using IsNull here, on this post form yesterday by Bob Larson: http://www.mrexcel.com/forum/showthread.php?t=569333

 

[Joe4]

You may also be able to use the NZ function, which you use to say what to use in the event that a certain field is NULL. The NZ argument has two arguments:

NZ(field to return, what to return if field to return is null)

Make sure that if you do use the IIF function, that you tell it what to use in the event that your condition is FALSE, or else your SUM may not work.

The IIF function has 3 arguments:

IIF(condition to check, what to return if true, what to return if false)