How do I use multiple parameters in a query

[Guest_imported]

Hi
I am in trouble. How can I use a parameter query with parameters belonging to different fields? i.e how to combine different parameters?

 

[tlbroadbent]

I assume you have a query with n number of columns or fields. And that you want to be able to select records based on multiple parameters - each parameter belonging to a different column. If that is the case then you would have a query like one of the following.

SELECT *
FROM tbl
WHERE OrderQty>[Enter Minimum Order Quantity] AND ProjID=[Enter Project ID];

SELECT *
FROM tbl
WHERE (OrderQty Between [Enter Minimum Order Quantity] AND [Enter Maximum Order Quantity]) AND ProjID=[Enter Project ID];

SELECT *
FROM tbl
WHERE Team Like NZ([Enter Team Name],"&quot & "*" OR TeamID=NZ([Enter Team ID],0)

Hope these samples help you get started. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin