Create a query from filters RRS feed

  • Question

  • User-1618168713 posted

    Hello All,

    I am a bit unsure of the best way to go about this. I have a form where data is entered, date ranges, usernames, passwords etc and when the button is pressed on the form it searches a database and returns values which match the values entered.

    I can't think of the most efficient way to do this, could anyone give some pointers on where to start?

    I thought perhaps of writing a query and then just putting in the variables which pick up the entered values and reading it all in as one big string something like:

    SELECT * FROM DB WHERE ProductID = "DateTxtBox" & "NameTxtBox"

    I haven't checked the syntax but this is just to give you a idea of what I am thinking.


    Tuesday, January 25, 2011 5:09 AM


All replies