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
> From: winberry.doyce@roadsysinc.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
>
>
>
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic () |
.
__,_._,___
Tidak ada komentar:
Posting Komentar