Forms that can expand columns on changing crosstab query

  • Thread starter Thread starter mansoor_goheer
  • Start date Start date
M

mansoor_goheer

Hi !

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

Regard

Gohee
 
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
 
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.
 
Back
Top