Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005

    Forms that can expand columns on changing crosstab query

    Hi !!

    Please help me to make a form that is based on a crosstab querry and it can adjust its rows as well as columns based on the changing out put of the crosstab querry !!!



  2. #2
    Hansford cornett Guest

    RE: Forms that can expand columns on changing crosstab query

    IF you find this out please let me know I could have used it several times in the past.

    I think this is the impossible as the report or form is not actually built until the query is run therefore the querry creates the format each time it is run..

    I did fake one crosstab query out a year or so back by creating a blank entry so all fields would display and then when I count I -1 to keep the data counts right.

    Hansford D. Cornett

  3. #3
    Duane Hookom Guest

    Re: Forms that can expand columns on changing crosstab query

    There is a sample file with dynamic crosstab reporting at I think the only way to accomplish this with a form involves a fair amount of code. Adding rows is easy. I think you would want to create a bunch of hidden text boxes that you can use when the crosstab generates more columns.

    Duane Hookom
    MS Access MVP

Please reply to this thread with any new information or opinions.

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. Add Columns to query
    By 4petessake in forum Access
    Replies: 0
    Last Post: 06-15-2007, 01:38 PM
  3. Replies: 0
    Last Post: 02-14-2007, 01:35 PM
  4. Criteria in Crosstab Query
    By wasim_sono in forum Queries
    Replies: 1
    Last Post: 12-12-2006, 05:14 AM
  5. Replies: 1
    Last Post: 07-17-2006, 06:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums