Forum Discussion
Dsum
I am trying to develop the following query/report in Access... I believe what I want is to Dsum EMESCst values from tblEMES and Dsum AMESCst values for tblAMES where tblWO WONo = WOOrder in...
Hi,
I can't judge if it's correct in logic, field types and some names due to lack of details, but in syntax you need 2 changes. The equals sign must be inside the quotes, and the parameters must be concatenated with ampersand:
SumofAMES: DSum("AMESCst","tblAMES","WOOrder=" & WONo)
SumofEMES: DSum("EMESCst","tblEMES","WOOrder=" & WONo)
If you get stuck, share more details and post the SQL text of the query you tried.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon