i have a database where records are entered daily. how do i total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database where records are entered daily. how do i total a figure in
a specific field and then sort it by date
 
This sound like there is one record entered per day. If this is the case
then totals are moot.
 
i have a database where records are entered daily. how do i total a figure in
a specific field and then sort it by date
Click to expand...

By creating a Totals query based on the table; use the Greek Sigma
icon (looks like a sideways M). Since we have no information about the
structure of your table it's hard to be specific; if you wish for more
specific answers, please post a more specific question.

John W. Vinson[MVP]
 
Assuming you have two fields "DateSold" and "SalesAmount" with multiple
entries each day and you want total sales per day as your output.

Open a new select query on the QBE panel and add the two fields as columns
in the query.

Go to the menu and select "View"; "Totals". That will put a total row under
each of the Fields and both will be set to "GroupBy". Change the one under
SalesAmount from "GroupBy" to "SUM" using the dropdown list. Set the sort
row under "DateSold" to sort descending.

Open your query. It should show your daily Sales Totals from today back.
 
Back
Top