Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    Chengdu
    Posts
    1

    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 !!!

    Regards

    Goheer

  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.

    GOOD LUCK
    --
    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 http://www.invisibleinc.com/divFiles.cfm?divDivID=4. 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