Criteria Input on Report

A

Allan

I have create a Union Query based on a table used for
collecting data for a 5 year Business Forecast. The Query
prompts the user for comparison periods (ie: 2005 vs
2006) in two separate prompts. The user would type into
each of the two prompts the comparative year.

This query is the basis for a report. I have the entire
report together and working well with one thing missing -
I would like to take the value from the criteria (2005 &
2006) and use it for the column headers. Currently, I
have the generic column names used in the query. It would
be a problem if the report was run twice. Once comparing
2005 to 2006 and a second time comparing 2006 to 2007.
The numbers would change but the column labels would
remain the same.

Allan
 
D

Duane Hookom

Can you change your column labels to text boxes? Then set the control source
to equal you criteria. ie:
=[Enter First Year]
 
A

Allan

As always you were right on. Thank you very much for the
assistance.

Allan
-----Original Message-----
Can you change your column labels to text boxes? Then set the control source
to equal you criteria. ie:
=[Enter First Year]

--
Duane Hookom
MS Access MVP


Allan said:
I have create a Union Query based on a table used for
collecting data for a 5 year Business Forecast. The Query
prompts the user for comparison periods (ie: 2005 vs
2006) in two separate prompts. The user would type into
each of the two prompts the comparative year.

This query is the basis for a report. I have the entire
report together and working well with one thing missing -
I would like to take the value from the criteria (2005 &
2006) and use it for the column headers. Currently, I
have the generic column names used in the query. It would
be a problem if the report was run twice. Once comparing
2005 to 2006 and a second time comparing 2006 to 2007.
The numbers would change but the column labels would
remain the same.

Allan
Click to expand...


.
Click to expand...
 
Top