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.
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.