creating report in access database

Posted on 2014-07-13
Last Modified: 2014-07-13
have attached db and excel sheet -
in the db- have created a report ( rpt1)
but am trying to create it to display like the excel sheet have attached-
is that possible?
thank you
Question by:davetough
    LVL 30

    Accepted Solution

    Add another grouping to Categories.
    Check and modify:

    Author Closing Comment

    Great Help!! thank you-
    ( you know i come to the site first using internet explorer and tried to download solution and it opened in an encrpyted text like text file- so closed internet explorer and used Mozilla- then when downloaded the database it opened fine- wonder if changes to ee- may have affected viewing with i.e. - or maybe just me)
    thank you
    LVL 30

    Expert Comment

    LVL 30

    Expert Comment

    This has to do with internet settings, how to open links.
    I looked into that, and changed a setting to let internet explorer decide. And now it opens as you are experiencing.

    Now I am removing the Internet explorer from the Open with list for accdb files using the registry. In firefox it does has an option to manage that.

    You may, otherwise, right click link and select save target as.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    794 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

    15 Experts available now in Live!

    Get 1:1 Help Now