Selecting Data In Table Based On Conditions for Multiple fields within it

Question

User1104400338 posted

Hello. I am using Microsoft Visual Studio, and in Access database I have a table called Batteries. It has the fields ID, Name, Capacity, size, and cost. I have connected each field in the table to dropdownlists as controls, so as to help me view the table based on each field I select in the dropdownlists or combination of fields. I have my select query as SELECT * FROM Batteries WHERE ID = ? OR Name = ? OR Capacity = ? OR Size = ? OR Cost = ?, but the table doesnot show whenever I choose a field in the dropdownlists or a combination of fields. Hence, I decided to connect only two fields to the dropdownlists, SELECT * FROM Batteries WHERE ID = ? OR Name = ?, but data in the table only shows when I choose both the ID dropdownlist and the Name dropdownlist; I can't choose one without the other.

What Select Query can I use (for all the fields included not just 2) so I can make the data in the  table apear when I choose a just field or a combination of fields?

Answer 1

User-821857111 posted

Try this approach for optional parameters: http://www.mikesdotnetting.com/Article/68/An-ASP.NET-Search-Engine-with-MS-Access-for-optional-search-criteria

Answer 2

User1104400338 posted

Hi. PLENTY OF THANKS TO YOU. A LOT OF THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!