Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

HELP with report

I am a programmer, but reports is not my strongest suite in Acces.. I have a user that must have a multi page report ASAP that looks like the attached.  

I have two tables for Orders that is related to the Order Details.
I have no problem creating the query, but how do I get a multi page report like this???
Any suggestion is GREATLY appreciated.

1 Solution
Kelvin SparksCommented:
Which version of Access - essentially a grouping report with page breaks set per store.

Jeffrey CoachmanMIS LiasonCommented:
What you are requesting would require either a Pivot table, or a Crosstab query.

However, you have two things working against you:
1. Crosstab queries and Pivot tables create their columns "dynamical", hence they are not well suited for "Reports" (where the fields are hard coded)
2. The "Stacked" column headings design aspect  will be a challenge, ...to say the least.

What did you use to generate the Report in the PDF? ...Why not just use that?

What is that second "Layout" in the PDF? (starting on page 4)
Is that relevant here?
Is that a separate report?

Agree with boag2000,

I would like to see a sample database with few fields to get the idea, then one can exapand to more fields. Explain the criteria to create the multi pages.
sharpapproachAuthor Commented:
Got me started down the path of Cross Tab Query and a Pivot Table

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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