| | |
|
|
|
Parameter Query |
|---|
| message from Reggie on 25 May 2004 |
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
|
| Graham R Seach replied to Reggie on 26 May 2004 |
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
"Reggie" <anonymous@discussions.microsoft.com> wrote in message
news:123e301c4429b$a58bc060$a401280a@phx.gbl...
|
|
Archived message: Parameter Query (MS Access Database)
