Hi thank you very much for your help.
I've tried what you've said and Immediate windows gave that;
[Project Name] like "Project*" AND [Diameter] >= 1 AND [Diameter] <= 10 AND ( [Manufacturer] = "Company 1" OR [Manufacturer] = "Company 2" ) ( [Project Type] = "Metro" OR [Project Type] =...
Hi,
I have database and I am trying to create a search form. I have 2 list boxes on the form one of them includes manufacturer and other includes project types.
When I use forms individually or with other variables the search works and gives me the what I am searching for. However when I use...