S
sz
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
a specific field and then sort it by date
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
This sound like there is one record entered per day. If this is the case
then totals are moot.
then totals are moot.
J
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]
K
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.
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.