Thread
:
Using a parameter in a report
View Single Post
#
2
May 24th, 2010, 04:18 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
Using a parameter in a report
Hi Paul,
Try this: ........ WHERE MyTable.Tag1 = [Enter Tag1 Value]
Steve
"Paul Kraemer" wrote in message
...
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
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]