Thanks for the help, but I already tried that. I am getting some errors when trying this within the query.
Here is the expression that I am using
=IIf([CheckDate]=[CheckDate],Sum([HoursReceiptAmtWages]))
When I run the query, I get an error,
"You tried to execute a query that does not...