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.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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, 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?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.