Using a parameter in a report

[Paul Kraemer]

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

 

[Steve]

Hi Paul,

Try this: ........ WHERE MyTable.Tag1 = [Enter Tag1 Value]

Steve
(e-mail address removed)

 

[Duane Hookom]

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/Forums/en-US/addbuz/threads?