Hi
I have a query that includes a number of defined calculations, such as "TotalCost: [Quantity]*[UnitCost]", and " MyYear: DatePart("yyyy",[Date1])".
I am trying to build another query based on the first, using these fields as criteria in a dsum and dcount expression.
My first question is:
Do I have to recalculate these in the second query or am I able to just reference and the name, and
Second:
If I have to recalculate these in the second query, could some please help me with the syntax?
What I am trying to achieve is Dsum( "AQuanityFiled]","FirstQueryName", "Field" = '" & [TotalCVost] & "'" and '" & [MyYear] & "'")
I hope this makes sense
Thanks
I have a query that includes a number of defined calculations, such as "TotalCost: [Quantity]*[UnitCost]", and " MyYear: DatePart("yyyy",[Date1])".
I am trying to build another query based on the first, using these fields as criteria in a dsum and dcount expression.
My first question is:
Do I have to recalculate these in the second query or am I able to just reference and the name, and
Second:
If I have to recalculate these in the second query, could some please help me with the syntax?
What I am trying to achieve is Dsum( "AQuanityFiled]","FirstQueryName", "Field" = '" & [TotalCVost] & "'" and '" & [MyYear] & "'")
I hope this makes sense
Thanks