Running totals in a Query & continue to add new records

surethom

New member
Local time
Today, 01:01
Joined
May 2, 2012
Messages
6
I have 2 querys Qry_Data & Qry_Data_total

Qry_data has a list of ingredients with there grams_per_pack
Qry_data_total sums the grams_per_pack from Qry_data

I then have a form that does some calculations & a dlookup to Qry_data_Total

I have tried a sum expression but that stops you adding new records.

My question is: = Is there a way to have a sum or running total on qry_data that also lets you add new records.

Thanks.
 

Users who are viewing this thread

Back
Top Bottom