Need to make two seperate SQL statements work together

[DoodlesMcKee]

Hi, not much experience in writing SQL statements. These two statements work fine in seperate queries but I need them to work in one query. Can they be put together? I appreciate the help. Thank you.



WHERE ((([Bid Information].State)=[Forms]![Dashboard].[txtEnterState1] Or ([Bid Information].State)=[Forms]![Dashboard].[txtEnterState2] Or ([Bid Information].State)=[Forms]![Dashboard].[txtEnterState3] Or ([Bid Information].State)=[Forms]![Dashboard].[txtEnterState4]))


WHERE ((([Bid Information].[Low Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*")) OR ((([Bid Information].[2nd Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*")) OR ((([Bid Information].[3rd Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*"))

Probably obvious but just in case - "State" is in one field. "Low Bidder", "2nd Bidder" and "3rd Bidder" are all seperate fields in unique records. When we choose the states (up to 4) and a vendor, we need to see the records where that vendor occured, whether in 1st, 2nd or 3rd place AND the other vendors that are in that record.

Example:

I want to see bid results in IN, IL, NY and OH where Vendor ABC bid. If they were second, who was first and who was third?

When I put the two statements in one query, all the states to come through so that's where I'm stuck. I can do some VB (not much but enough to get by on), if that's a better option.

I thank you for your time.

[ssanfu]

I'm not sure I understand what you want, but you can try:

WHERE ([Bid Information].State = [Forms]![Dashboard].[txtEnterState1] Or [Bid Information].State = [Forms]![Dashboard].[txtEnterState2] Or [Bid Information].State = [Forms]![Dashboard].[txtEnterState3] Or [Bid Information].State = [Forms]![Dashboard].[txtEnterState4]) AND ([Bid Information].[Low Bidder] Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*" OR [Bid Information].[2nd Bidder] Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*" OR [Bid Information].[3rd Bidder] Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*")

Make a copy of one of the queries that works, switch to SQL view and replace the WHERE clause with the above clause.

[Bob Fitz]

What is the point of this:
WHERE ((([Bid Information].[Low Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*")) OR ((([Bid Information].[2nd Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*")) OR ((([Bid Information].[3rd Bidder]) Like "*" & [Forms]![Dashboard].[txtEnterVendor] & "*"))
I don't think this filters anything, does it?