iff statement in access query is making my data shrink

O

opeyemi1

Hello all:

In my query, I am pulling some fields from an existing table. Th
fields I am pulling include: Transaction In State Since date and Logge
Date. I want access to provide me with Transaction in State Since Date
but if Transaction in State Since date is null or blank I want acces
to replace those cells with the Logged Date, if the logged date is als
blank when the transaction date is blank, then it should just give m
whatever is in the Transaction in State Since cell (in this case,
blank or null cell). I used the following iff statement
(=IIf(IsNull([Invoice StateJan 14-April30]![Transaction in Stat
Since]),[Invoice StateJan 14-April30]![Logged Date],[Invoice StateJa
14-April30]![Transaction in State Since]);

But I noticed without the iif statement, I had about 13,919 records
after I used the iff statement I had about 9197 records.

Does anyone know if there is something wrong with the iff statement o
if I should not be using an iff statement in the first place, pleas
tell me what to use instead.

Thanks a lot for your patience.


opeyemi
 
Top