Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014

    Unanswered: Dynamic crosstab header help

    I have a crosstab query I need to create a report for filtered by a purchaser and under each purchaser they are grouped by segment. however the segment names can vary based on purchaser. for instance
    Purchaser A has 33 segments names
    Purchaser B has 8 segments names
    Purchaser C has 1 segment name
    Purchaser D has 5 segments names

    I'm looking to set up the segment names in the report to be dynamic so that when the user changes the purchaser they need for the report the proper segment names will be shown.

    Any help would be great.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    dynamic in what way?
    a cross tbae query is by defnition dynamic.....

    What I suspect you need to do is run the query once for each Purchaser and then the crosstab query should only tabulate for that customers segment. dunning it for all purchasers will try and tabulate for every segement, irrespective of whether that purchase has that segment
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2009
    Kerala, India

    Dynamic crosstab header help

    The following Link is all about Crosstab Query and Dynamic Report:

    Dynamic Report (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts