Parameter Query

  • Thread starter Thread starter Reggie
  • Start date Start date
R

Reggie

I am trying to buid a parameter query, that will look for
the same value in multiple fields with one prompt, i have
been unable to figure it out..if it's possible, could
someone help me out

thanks in advance
 
Reggie,

Yes it's possible.

PARAMETERS [Enter a value] Text(50);
SELECT Field1, Field2, Field3
FROM Table1
WHERE Field1 = [Enter a value]
AND Field3 = [Enter a value]

....or...

SELECT Field1, Field2, Field3
FROM Table1
WHERE Field1 = [Enter a value]
AND Field2 = [Enter a value]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top