Re: Use crosstab column heading in a calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Duane,

Now that I've got all the calculations working, I would like to use this
crosstab query as the datasource for a subform. I would prefer a continuous
subform to a data***. How do I display in a subform, a datasource whose
field names and the number of fields will change depending on the results of
the crosstab query?

Bill

Duane Hookom wrote:
>You can use a reference to a control on a form in the same way that you
>would hard-code a value. As I stated earlier, crosstabs expect you to
>identify the data types of all parameters.
>
>> Duane,
>>
>[quoted text clipped - 36 lines]
>>>>>>>
>>>>>>> Bill

--
Bill Reed

"If you can't laugh at yoursel, laugh at somebody else"

Message posted via http://www.accessmonster.com
.

Quantcast