crosstab query

  • Thread starter Thread starter Ozer....
  • Start date Start date
O

Ozer....

hi;
when i use crosstab query in forms i can't add or see some coloumns...
because in crosstab query coloumn names are variable....

have any idea...?

thanks...
 
If there is a finite, known set of possibilities for the column headings:
1. Open the query in design view.
2. Open the Properties box (View menu).
3. List all the possible values in the Column Headings property.
Then all headings will appear, even if the query does not return values for
the column.

If the column headings are completely variable, you can only to this
programmatically. You will need to OpenRecordset() in code to determine what
field names you need, and then assign those fields to the ControlSource of
the text boxes and the Caption of the Labels on your form, hiding any you
don't need this time, and possibly assigning the Left and Width properties
to fit them to the Form.Width.
 
Back
Top