How do I return a value on multi criteria?

[smc678]

On a report I want to Dlook up using if a name and a date match on a query line it will return the total that is associated in that same line. What do i need to add to the below is if

=DLookUp("[Total]","qryaQFFSumOfTotal10day","[AssociateName]=Reports!rprtQFF10day![AssociateName]") & qryaQFFSumOfTotal10day","[ErrorDate]=Reports!rprtQFF10day![Date1]") if null = 0?

[alansidman]

I find it easier to do all my calculations in the query itself and then use that query as the record source for the report. Seems a little bit cleaner.

[smc678]

How do you do that on the query?

[smc678]

How do you do that on the query?

[smc678]

I need to return the sum of total from the qry to the rpt on error date by associate name.

[alansidman]

Here is a tutorial on aggregate queries.

Scroll down to the Group By section

http://www.techonthenet.com/access/queries/index.php