problem using DSum??

[marlun]

Hi!
I want to get a value in a textfield on a form using DSum.
When the form open I have an event procedure that sums up the value in a storage for each market. INow I have this line:

Forms!Ekonomi!Saldo = DSum("Antal*Lagervärde_avg", "tblLager",[ ])

The problem is that I dont know how to write the criteria.
In table A (tblLager) I have the amounts to sum. In table B I have the market each product belong to. What I need is a way to sum the totals in each marketgroup. Hope you understand what I mean.

Please help

 

[BillPower]

It goes something like this:

Forms!Ekonomi!Saldo = DSum("[Antal*Lagervärde_avg]", "tblLager", "[Antal*Lagervärde_avg] = 'Fosters'&quot

Regards

Bill

 

[marlun]

Hi again, sorry I don't I understand what you mean. What is Fosters???

 

[BillPower]

Only one of the most popular Australian Lagers in the UK.

Actually, in retrospect try:

Forms!Ekonomi!Saldo = DSum("[Antal*Lagervärde_avg]", "tblLager", "[FieldNameToLookup] = 'Criteria'&quot

Or another way if the Criteria is being selected in a Control:

Forms!Ekonomi!Saldo = DSum("[Antal*Lagervärde_avg]", "tblLager", "[FieldNameToLookup] = " & Forms!Ekonomi!ControlNameStatingCriteria)


If this doesn't work first time experiment with and without the 's (apostrophes) enclosing the criteria.

Bill