Criteria Input on Report

  • Thread starter Thread starter Allan
  • Start date Start date
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
 
Can you change your column labels to text boxes? Then set the control source
to equal you criteria. ie:
=[Enter First Year]
 
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...
 
Back
Top