Steve Eckerman
asked on
Formatting an Access table using an SQL statement
Attached to this question are 2 Excel spread sheets. The first spread sheet is the result of a SQL query that pulls out our yearly projected budget items. This Excel sheet is called Total Budget Summary. The second Excel sheet is the same data but my boss has reformatted it to reflect the various account codes that make up different pieces of our business. This Excel spread sheet is called Total Budget Summary Reformatted. Is there a way to write a query that will produce the reformatted spread sheet from the initial spread sheet of raw data? Please advise. Thanks
There may be. But, there is not spreadsheet attached.
ASKER
Sorry about that they are posted now.
These are version 2003 or earlier (xls). What version of products do you have installed?
One can create a table in Access to establish the print order of the cross tab query you have established.
Would you want to print it as a report from Access or export it as an Excel file?
One can create a table in Access to establish the print order of the cross tab query you have established.
Would you want to print it as a report from Access or export it as an Excel file?
ASKER
We are using Access and Excel 2003. I would like to export it as an Excel file if possible.
After importing the crosstab and the reformatted as tables, I made changes to the design of the reformatted table to be able to order a query to display your results. This can be exported to Excel or used as the basis for a report in Access. Subtotals can be inserted in Excel and grouping can be used in Access to establish the totals. Database1.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The query used to create the Total Budget Summary is a Select query. Do I need to create a crosstab query and use the select query along with the ExcelOutPut query. I am kind of new to this.
ASKER
It works great!!! You did a great job!!! Thanks alot!!!
ASKER
Great job!
ASKER