Duane,
A union query is a good idea and easy. I'm interested in what you mean by Automation though. Could you explain?
Doyce
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Monday, July 08, 2013 1:46 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Transfer to spreadsheet totals
You could use a union query that adds a totals record to the bottom. Automation is another solution.
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
> From: winberry.doyce@roadsysinc.com<mailto:winberry.doyce%40roadsysinc.com>
> Date: Mon, 8 Jul 2013 17:11:34 +0000
> Subject: [MS_AccessPros] Transfer to spreadsheet totals
>
> Hello friends,
>
> I'm transferring data from a query to Excel. Is there an easy way to get totals at the bottom of the columns that are numerical without opening the spreadsheet after the fact and adding them manually? I'm using Access 2010.
>
> Doyce
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar