DSUM with multiple criteria in same query

[maabbas]

Hello everyone,

I am trying to use the DSUM in query which look the value in another qry based on 3 criteria, somehow or maybe my lack of knowledge I am unable to get the result.

please see the following syntax

=DLookUp("[SumOfDT_Minutes]","[qry_sum_DT]","[qry_sum_DT].[DT_Date]=[qry_DPR].[P_Date] And [qry_sum_DT].[DT_Line_ID]=[qry_DPR].[P_Line] And [qry_sum_DT].[DT_Product]=[qry_DPR].[P_Code]")

any help will be greatly appreciated.

Thanks

 

[xenou]

Possibly you can use DLookup in that third part of the DSum function. You can't just put another query in there by name as if it will run it or something.

 

[maabbas]

Possibly you can use DLookup in that third part of the DSum function. You can't just put another query in there by name as if it will run it or something.

my apologizes, I enter Dlookup in the code instead of Dsum. will you please explain how will i do that?

Thanks

 

[xenou]

Well, you want some value from a query in your DSum() criteria, right? So DLookup does that kind of thing (maybe).
Example:

=DSum("[SumOfDT_Minutes]","[qry_sum_DT]","[qry_sum_DT].[DT_Date]=" & "#" & DLookup("P_Date","qry_DPR") & "#")