report based on a crosstab query 
Author Message
 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?!  |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



Mon, 14 Jan 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. report based on a crosstab query

2. Adding a field to a table based on CrossTab Query

3. Formula based on Crosstab report row data - possible?

4. Crosstab Query for Report

5. dynamic report formatting from crosstab queries??

6. Crosstab Query/Conversion/Report Generation...

7. query regarding Crosstab report

8. multiple queries into a crosstab query in VB

9. multiple queries into a crosstab query in VB

10. Report based on two queries

11. Using forms to select a report from multiple base queries

 

 
Powered by phpBB® Forum Software