shop Satistics forms for access

S

Simon

I have a database that does my shop. I am about to create a few query
to sort out satistics like average sale , average profit ect, does any
one have any good examples they have built to calculate satistics from
a shop database

thanks
 
S

Steve

Probably all the statistics you want can be gotten from Total queries. For
example, create a quey based on your Sales table. Click on the Sigma button
(looks like capital E) in the menu at the top of the screen. In the Sales
field change Group By to Avg. You can also set a criteria on SalesDate to
get the average sales in a selected date range.

Steve
[email protected]
 
Top