shop Satistics forms for access

  • Thread starter Thread starter Simon
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top