I want a query that will give me the totals per order so it would look
like this,
1 $4.15
2 $2.00
3 $2.50
4 $5.50
As you can see I'm new to this and I thank you for your help.
In the query designer pull down the fields ORDER and SHIPCOST from your table.
From the main menu choose...
View
Totals
This will cause a new row (Total) to appear in the designer grid. Under ORDER
leave the default entry for Total of "Group By". Under SHIPCOST choose "Sum".
That's it.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Re: Report is making too many numbers ... from the $'s being listed more than once in the query.... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ... (microsoft.public.access.reports)
Re: Running balance from two tables ... the TOTALS button and show a totals line in the query,... my total additions and my total costs and see how much money is in my ... What I'd love to do with it is have something pop up when the balance is ... (microsoft.public.access.queries)
RE: Crosstab Worries ... I copied your sql into my Northwind and I created a form off that query and I ... concerned, the recordsource is three letters, Jan, Feb, but the text box is ... You can sum a field from the record source but not ... with their totals in each of the twelve columns. ... (microsoft.public.access.queries)
RE: Cannot get code to work for API Save Dialog Box ... While I still need help on that other issue, I fixed the totals problem I had. ... The first spreadsheet placed where I told it to be contains the incorrect ...Set xlSheet = Nothing ...query, you will have to add the field to your query. ... (microsoft.public.access.forms)
Is ROLLUP really better than doing a nested query when rank is involved? ... I meant here by homing in: within the same query - using ... sales BUT with their subtotals as well... ... the totals and subtotals... ... use min(rank) in the same aggregation, ... (comp.databases.oracle.server)
