HELP with report

Posted on 2011-10-26
Last Modified: 2013-11-28
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.

Question by:sharpapproach
    LVL 22

    Expert Comment

    by:Kelvin Sparks
    Which version of Access - essentially a grouping report with page breaks set per store.

    LVL 74

    Accepted Solution

    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?

    LVL 30

    Expert Comment

    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.

    Author Closing Comment

    Got me started down the path of Cross Tab Query and a Pivot Table

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now