Create Access reports from crosstab queries

by Mary Ann Richardson | Nov 07, 2006 2:17:00 PM

Tags: Microsoft Office, Databases, Mary Ann Richardson, Microsoft Access, Microsoft Office Suite Access Tips Newsletter

Takeaway: Did you know that you can create a report from your Access file's crosstab data? Here's how to organize and clarify your data in a unique Access report.

Sometimes a crosstab query presents data in a more logical fashion than a simple datasheet view—and it may even make a better Access report. Although crosstab queries are designed for interactive analysis, you can convert the results of that analysis into a printed report. To do so, follow these steps:

1. Open the database that contains your crosstab query.
2. In the Database window, click Reports under Objects.
3. Select your crosstab query from the drop-down list and click OK.
4. If necessary, click the Field List button in the report toolbar and select all fields by clicking the first field, press [Shift], and then click the last field.
5. Drag all selected fields to the detail section of the report.
6. Right-click the first field's label and select Cut.
7. Right-click within the header section of the report and select Paste.
8. Repeat steps 6 and 7 for each report label.
9. Drag the labels in the report section to an appropriate position for report column headers.
10. Drag the text boxes in the detail section to position them under their respective column header.
11. Complete the formatting of the report as desired.

The resulting report will list the crosstab data under the appropriate column headings, as shown in the crosstab query results.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Print/View all Posts Comments on this article

Flexibility with New Fields jkowolf | 11/08/06

Yes you would Len Harding | 11/08/06

RE: Create Access reports from crosstab queries dwayne.fitz@... | 06/02/08