report based on a crosstab query
Quote:
> I have a crosstab query with Column Headers based on the quarters. It works
> great unless you try to run the report for the current year before the 4th
> quarter. (or 3rd qtr if its before July, etc.) Since there is no field
> created in the query, the text box on the report has an invalid Control
> Source. I get an error and the report terminates.
> Does anyone have a routine that would get me around this? I have been
> searching for a couple days without any luck.
Dynamically set the ControlSource and visibility of anything that's not going
to be used with the current data...
--
HTH
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| gHaD (Aaron Robinson) |The Never-Ending Commute|
| MJM-PC Solutions, Inc. |Web & Database Developer|
| Chicago, IL | Will work for Dew?! |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
