Parameter Query

R

Reggie

I recently posted a question :

trying to build a parameter query that will look for the
same value in multiple fields with one prompt for the
criteria for all(the criteria will be the same for
all)...Mr Seach was gracious enough to respond with:

parameters [enter a value] text (50);
select field1, field2, field3
from table 1
where field1 = [enter a value] and field2 =[enter a value]

or....
select field1, field2,field3
from table1
where where field1 = [enter a value] and
field2 =[enter a value]

i'm sorry but i am ignorant as to where and how these
statements should be input...if anyone could help this
poor soul..it would be appreciated

thanks in advance for any help
 
Top