I'm not sure this qualifies as a query but it is related.
Using Dsum() I want to sum up one field only on rows that have a date field that is null. I can't quite figure out how to set that criteria properly.
A VBAish explanation of what I'm trying to do
Anyone happen to know?Code:If isnull(datefield) then Sum = Sum + Amountfield