Calculated Field: Different between 2 Fields with same Name on Different Tables

[PicoTTS]

Hi,



I am trying to create a calculated field in a query. I am having problems setting the criteria. I have ORDNUM

I have a field called "ORDNUM" on 2 tables. One table is called [Orders] and the other is a query called [Sales]

The formula I am using:

Quantity: DLookUp("Quantity","[Orders]","[Orders]![ORDNUM] = '" & [ORDNUM] & "'")

Basically I want DSum function to add the quantity field from the Orders table when the ORDNUM field from another table matches the ORDNUM on my current query.

I hope i explained this properly.

Thanks for the help.

[CJ_London]

is ORDNUM numeric? if so then you need to remove the single quotes

But why not just join the two tables together?