S
SomeCallMeTim
Guest
I want to export an entire report to Excel, but when I try to it only exports the data from my query. How can I get Access to export all the manipulated data as well?
S
SomeCallMeTim
Guest
Basically what I am doing is setting up accounting journal entries. I pull sales data based on dates that are input by the user. Once those dates are pulled I add the data together to get totals. All the above will export to Excel.
Then I take the totals and multiply them by certain estimated values to get things like rent due, COGS, etc. which are what need to be entered. The whole report looks something like this :
Date 1.........x1+x2+x3......................x1.......x2........x3
Date 2.........y1+y2+y3......................y1.......y2........y3
Total...x1+x2+x3+y1+y2+y3............x1+y1...x2+y2...x3+y3
Account 1..........Total Sales * Rent Percentage
Account 2..........Total Sales
Account 3..........Total Sales * COGS Percentage
The top portion (the query data) exports; the bottom portion of the report (the manipulated data) doesn't. Any ideas? Thanks.
Tim
Then I take the totals and multiply them by certain estimated values to get things like rent due, COGS, etc. which are what need to be entered. The whole report looks something like this :
Date 1.........x1+x2+x3......................x1.......x2........x3
Date 2.........y1+y2+y3......................y1.......y2........y3
Total...x1+x2+x3+y1+y2+y3............x1+y1...x2+y2...x3+y3
Account 1..........Total Sales * Rent Percentage
Account 2..........Total Sales
Account 3..........Total Sales * COGS Percentage
The top portion (the query data) exports; the bottom portion of the report (the manipulated data) doesn't. Any ideas? Thanks.
Tim
Similar threads
