issues with DSum

[ozdemirozgur]

Hi,

i am new to the access and need some help. I am trying to calculate a total using Dsum. I have two tables. the main table and the transactions. Both have the stockId. in addition, trasactions ahve transaction type and also year. I am calculating the total within a Do While statements

Nz(DSum("TotalQuantity", "Combined_Annualized", "StockId=Main!sotkId and Trans = 'P' and Year ='2010'),0)

I do not know why but the above statement does not work. please help

tahnks, ozgur

[pbaldy]

I suppose this is part of your double nested loop thing? See if this helps:

DLookup Usage Samples

[ozdemirozgur]

Hi Paul,

My one is a bit different, I have a do while statement need to calcualte the total for a report. I have the following statement based consructed using the link you sent but the following did not work. Do you have nay idea what is wrong there?

Main10_2000_Combined.OO_Rem_N_2001 = DSum("SALARY", "REM10_2000_Combined_Annualized", "COY_ID = " & Coy_Id1 _
& " AND OO_Rem_Pos = '" & Pos & "'" _
& " AND Rem_Year =#" & 2002 & "#")

thanks

[pbaldy]

Year is probably a numeric field, so no delimiter around it, or if text you had it right to begin with. Since it's a fixed value, I wouldn't bother concatenating it. I would do it all on one line until you get it working; that way you're not debugging both line continuation issues and formula issues at the same time.