If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reference page header to query parameters
How do you reference a page header in a report to return the parameter that
you selected in your query? For example, I have two calculated fields in my final query based on two other queries. The two other queries contain the parameters. The parameters are for month, year and quarter. So if I answer my parameters like: Month1: 2 Year1: 2010 Qtr1: 1 Month2: 1 Year2: 2010 Qtr: 1 I want my report headers to reference my selections and return in my report’s page header: Feb 2010 Qtr1 Jan 2010 Qt1 I’ll be so incredibly relieved if I can get this to work. I’ve wasted a colossal amount of time trying to build an unbound form to do this but it seems to be out of my reach. I sure hope this isn’t too complicated. Thanks for any help. Kay |
#2
|
|||
|
|||
Reference page header to query parameters
IMO, there is no good reason to use parameter prompts in queries. All user
interaction should be through controls on forms. That said, you can simply place the same parameter in columns. Assuming you have a parameter like [Enter Year], you can create a new column in your query of: EnteredYear: [Enter Year] Again ;-) a much more professional solution is to always use controls on forms for user interaction. -- Duane Hookom Microsoft Access MVP "AccessKay" wrote: How do you reference a page header in a report to return the parameter that you selected in your query? For example, I have two calculated fields in my final query based on two other queries. The two other queries contain the parameters. The parameters are for month, year and quarter. So if I answer my parameters like: Month1: 2 Year1: 2010 Qtr1: 1 Month2: 1 Year2: 2010 Qtr: 1 I want my report headers to reference my selections and return in my report’s page header: Feb 2010 Qtr1 Jan 2010 Qt1 I’ll be so incredibly relieved if I can get this to work. I’ve wasted a colossal amount of time trying to build an unbound form to do this but it seems to be out of my reach. I sure hope this isn’t too complicated. Thanks for any help. Kay |
#3
|
|||
|
|||
Reference page header to query parameters
Thanks you so very much for this answer!!! Not what I really want but it
will have to do. I definitely agree with you that the unbound form is the way to go but it seems you have to be very experienced in order to build one for the parameters that I described...believe me, I've tried!!! Thank you, Kay "Duane Hookom" wrote: IMO, there is no good reason to use parameter prompts in queries. All user interaction should be through controls on forms. That said, you can simply place the same parameter in columns. Assuming you have a parameter like [Enter Year], you can create a new column in your query of: EnteredYear: [Enter Year] Again ;-) a much more professional solution is to always use controls on forms for user interaction. -- Duane Hookom Microsoft Access MVP "AccessKay" wrote: How do you reference a page header in a report to return the parameter that you selected in your query? For example, I have two calculated fields in my final query based on two other queries. The two other queries contain the parameters. The parameters are for month, year and quarter. So if I answer my parameters like: Month1: 2 Year1: 2010 Qtr1: 1 Month2: 1 Year2: 2010 Qtr: 1 I want my report headers to reference my selections and return in my report’s page header: Feb 2010 Qtr1 Jan 2010 Qt1 I’ll be so incredibly relieved if I can get this to work. I’ve wasted a colossal amount of time trying to build an unbound form to do this but it seems to be out of my reach. I sure hope this isn’t too complicated. Thanks for any help. Kay |
Thread Tools | |
Display Modes | |
|
|