Hello again all,
Looking for help with my nested if statement, it works correctly for the "if true" and "then" parts. Here is what I have for a query field:
Gas_Capacity: IIf(Year([Equip_Add_Rem_Log].[Date_Changed])>[year],IIf(([Equip_Add_Rem_Log].[Removal]=False),[Equipment].[Gas Capacity],"0"))
My problem is, if there is no "year(...)" greater than "[year]" on the table, the query returns a blank field (is this a null). How do I get the query to recognize a "" as a false return on the first "if true"?
Hmm, now that I think of it, it could possibly be an infinite return of falses if set up wrong. My head is spinning...any help would be greatly appreciated.
Shawn