Getting Totals between 2 Dates

[raiderman69]

Hello,

Anybody that can assist me with building a query utilizing Query Wizard or Query Design to will allow me to find the total of all the numbers in a specific field between 2 dates with
the data coming from 1 table.
Simply put, I would like to be able to choose the date range and have my query give me a single grand total not each individual entry between the chosen date range.

Any Help would be greatly appreciated.
Thanks in Advance

[June7]

This is an aggregate (Totals) query without any grouping.

Open query designer, select the table, click Totals on the ribbon, select field to sum, make choices in grid.

The resulting SQL statement will be like:

SELECT Sum([quantity field]) AS SumQty WHERE [date field] BETWEEN [enter start date] AND [enter end date];

That should result in a single record with a single field.

Access Help has more info.

[raiderman69]

Thanks June7,

I figured out how to get the totals with your advice and some other suggestions on the internet.
I was wondering if there was a way to figure out the totals of Field going top to bottom and left to right.
Backround info.
All Data is coming from 1 table.
the column layout of my query is listed below
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8
Date Name Total Total Total Total Text Grand Total (of all the Numeric Columns to the left of this column)

I was wondering if I could get the Totals from each of the above columns in the last row of my query.

Also, How can I get my report to fit a access report to fit on 1 Page, I have tried to mess with page setup till I almost had a nervous breakdown.

Thanks In Advance June7 and Thanks to Anyone Else with some suggestions.

[June7]

Open table or query in datasheet view, click Totals button on the Home tab. This will open a row at bottom of query. Pick the desired function under each field. However, these calcs are not actually in the table and will not show in form or report. That will required calcs in textboxes in footer sections.

Why does your report not fit on one page? Are there too many records? Attach screen shot of the report in design view.