Table Total

[bw]

I have a table in use, that I am restricting to one record, which is used as
the total number of items (call them apples), to be considered for
calculations elsewhere on Forms and Reports. I guess this is looked at as
an unbound field that remains constant for all calculations, until the value
in the table changes (infrequently).

So CURRENTLY, the table consists of AppleKey (autonumber field, Validation
Rule = 1), and TotalNumApples (number field).

I'd like to change the table so that it ALSO acts as a history file. The
table would include the number of Apples added, and the date the Apples were
added (but not necessarily the total of all Apples added).

The PROPOSED table would consist of AppleKey (autonumber field),
NumApplesAdded (number field), DateAdded (date field)

So my question is, how would I use this new table to:
Calculate the total number of Apples in the table for a report (and store
it where?).
Use this total number of Apples added as my unbound field for calculations
as I currently do.

Thanks,
Bernie

 

[Jeff Boyce]

Bernie

Take a look at the DSum() function.

 

[bw]

Thanks Jeff !

I have created a query that has the value 245 for the DSum function, and the
245 is in the table 3 times (there are 3 records in the Table). The number
245 is the correct total, but when I use it in a Report, everything is
repeated 3 times. All I want to do is use that 245 total once.

Can you explain how?

Thanks again,
Bernie

 

[bw]

I've got it!
I used a query to sum the values. Everything works like it did with only
one record.

Thanks for the help,
Bernie