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

[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

 

[Duane Hookom]

This sound like there is one record entered per day. If this is the case
then totals are moot.

 

[John Vinson]

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

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]

 

[Kc-Mass]

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.