• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
submarinerssbn731
Asked:
submarinerssbn731
  • 7
  • 4
1 Solution
 
submarinerssbn731Author Commented:
0
 
Richard DanekeAdjunct FacultyCommented:
There may be.   But, there is not spreadsheet attached.
0
 
submarinerssbn731Author Commented:
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
submarinerssbn731Author Commented:
Sorry about that  they are posted now.
0
 
Richard DanekeAdjunct FacultyCommented:
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?
0
 
submarinerssbn731Author Commented:
We are using Access and Excel 2003.  I would like to export it as an Excel file if possible.
0
 
Richard DanekeAdjunct FacultyCommented:
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
0
 
Richard DanekeAdjunct FacultyCommented:
In your database, you can do this using the crosstab query as a source instead of the imported table.  This will save you a step.
0
 
submarinerssbn731Author Commented:
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.
0
 
submarinerssbn731Author Commented:
It works great!!! You did a great job!!! Thanks alot!!!
0
 
submarinerssbn731Author Commented:
Great job!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now