View Single Post
  #1  
Old May 24th, 2010, 04:09 PM posted to microsoft.public.access.reports
Paul Kraemer
external usenet poster
 
Posts: 80
Default 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