How do I create a query with dynamic numbers

[wheels27]

how do i create a query that will recognize a value(meaning the number of line items in a table column by adding thier total then dividing them by the number of items in that column, but the number of items changes when one is deleted
so in other words the divide by number changes automaticly,

1. how do i get the divide by number to automaticly update

2. get a grand total of all added in the one column

3. also average each number in the field based off the total

 

[BanditWk]

Are you doing this in a Query or in a Report? Or are you trying to summate in the Query? If a Report is based on this Query, just get the basic data in the Query and do the summation on the Report.

HTH
Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."