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
|
|||
|
|||
Using a parameter in a report
Hi,
I am using Access 2007. I have created a report where the RecordSource is set to something like the following: SELECT MyTable.Tag1, MyTable.Tag2 FROM MyTable WHERE MyTable.Tag1 = 999; The WHERE clause is hard coded so that it only looks for records where Tag1 = 999. Rather than having this hard-coded, I would like to make use of a parameter so that when I run the report, it will ask me to enter the Tag1 value I want to use for filtering the report. If anyone can tell me how to do this or point me towards something I can read that would be helpful, I'd really appreciate it. Thanks in advance, Paul -- Paul Kraemer |
#3
|
|||
|
|||
Using a parameter in a report
I don't care for parameter prompts. Consider adding a text box (or maybe a
combo box) on a form to use for the criteria. Then your SQL might look like: SELECT MyTable.Tag1, MyTable.Tag2 FROM MyTable WHERE MyTable.Tag1 = Forms!frmMyCriteria!cboTag1; -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Paul Kraemer" wrote: Hi, I am using Access 2007. I have created a report where the RecordSource is set to something like the following: SELECT MyTable.Tag1, MyTable.Tag2 FROM MyTable WHERE MyTable.Tag1 = 999; The WHERE clause is hard coded so that it only looks for records where Tag1 = 999. Rather than having this hard-coded, I would like to make use of a parameter so that when I run the report, it will ask me to enter the Tag1 value I want to use for filtering the report. If anyone can tell me how to do this or point me towards something I can read that would be helpful, I'd really appreciate it. Thanks in advance, Paul -- Paul Kraemer |
Thread Tools | |
Display Modes | |
|
|