Re: Use crosstab column heading in a calculation

Duane,

Right, I'm developing the code to do that, but that's the point. If only
there were a control that would simply display the results of any query on a
subform, regardless of it's # of fields or it's design. Or, better yet, if a
subform could be used as a kind of blank display screen to display the
results of any query. Maybe in my next life!

Thanks for all your help,

Bill

Duane Hookom wrote:
>You can easily show the results of a crosstab in a form or subform if the
>crosstab has defined column headings. You can create reports with either
>static or dynamic if you find the solutions. I have given you a link to a
>sample application that I created that accepts dynamic columns in a subform.
>
>> When I do that, I get error msgs like "... can't use crosstab query..."
>> It sure is frustrating having created this beautiful crosstab query with
>[quoted text clipped - 16 lines]
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Bill

--
Bill Reed

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

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

Relevant Pages

  • Re: Question on displaying repeating data
    ... Next, I have to choose the link from the main form, to the subform. ... >> of historical quotes. ... The query logic is relatively simple. ... >> My problem is that I don't know how to display this. ...
    (microsoft.public.access.forms)
  • Re: Conditional formatting in a Crosstab Query
    ... decide on a maximum number of months to display on the form. ... that makes the row heading a relative month number: ... >But now I have another problem.Since this form is generated by a crosstab ... >query and the fields are filtered months ),next month I will have the ...
    (microsoft.public.access.queries)
  • Re: Subforms & Crosstab Querys
    ... If that doesn't meet your needs, consider the crosstab reports at ... "Duane Hookom" wrote: ... requery of the subform control? ... "qryScheduledInstalls" is the query that actually references the form ...
    (microsoft.public.access.forms)
  • RE: Requery Sub-Subform Crosstab
    ... the SQL property of an query or source query. ... The 6 subforms are updated through the subform Link ... But I can't get the 2nd Sub with the crosstab to "work". ... updated whenever a new Org is chosen in cboOrgs. ...
    (microsoft.public.access.formscoding)
  • Re: Subforms & Crosstab Querys
    ... Here is the crosstab SQL: ... "qryScheduledInstalls" is the query that actually references the form field ... "Duane Hookom" wrote: ... I used your code for a subform and it works great except for one problem. ...
    (microsoft.public.access.forms)