Adding totals from seperate records

[billheath]

If this has been done before, please help me to find it.

I need to add the totals from the current form and the one just before it. Basically I need to average the 2 totals. The id field is auto numbered so it should be easy but so far I haven't got it to work.

 

[dhookom]

Can you define this in terms of tables and fields? Forms don't have records, they just display.

Duane
Hook'D on Access
MS Access MVP

 

[billheath]

Sorry.
I tried to use this expression:
Dim c As Currency
Dim fld As Single
fld = Me!ID - 1
'c = DLookup("stock_total", "St_Daily_Value", "[ID] = '" & fld_ & "'")

I was trying to use the current AutoId -1 to give the criteria for the table record to get the total from. (In other words, to compare the data from the previous record.
I have changed the criteria around several times. The current error is "Data Mismatch in the criteria statement.)

Thanks for answering.

 

[dhookom]

Do the records need to be updateable? Don't you have different stocks?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

What about this ?
c = DLookup("stock_total", "St_Daily_Value", "ID=" & fld)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[billheath]

Thanks, That worked!