Crosstab query on form?

Posted on 2009-04-17
Last Modified: 2013-11-29
Hi - is it possible to display a cross tab query in form view?  I'm trying to keep my users with switchboard access only rather than having them search through the core queries etc. to find this and I'm having a heck of a time getting to go on a keeps erroring out.  Thoughts?  Thanks!
Question by:daisypetals313
    LVL 28

    Expert Comment

    If you are using a crosstab query then almost certainly you will need to use FixedColumnHeadings in order to use this in a Form Or Report, exspecially if your query is using variable date such as dates where not all fields are used.
    In 2007, not sure about 2003 you can use a Pivot Table rather than a cross tab.
    Cheers, Andrew
    LVL 74

    Accepted Solution


      "I'm trying to keep my users with switchboard access only rather than having them search through the core queries etc."

    Then another option would be to make a crosstab query "Menu", and then make this menu a choice on the switchboard?

    Sample attached


    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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 different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    761 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

    14 Experts available now in Live!

    Get 1:1 Help Now