Query Search

[k209310]

Is there a way of creating a query to search a given collum in a table and then find a specified set of figures.

Ie search collum 1 for all cells containg the number 25 and then diplay that entire row of information.

 

[wh00t]

create a standard query and select all fields that you wish to display, then in the Criteria section for the field that you wish to search, simply enter what you would like it to find.

 

[k209310]

I need the SQL if possible because i have to link this to VBA within an excel document. This allows the user to request a the info they need via a text box.

I have discovered that i can assign a variable from the control in excel and then use the variable from within access. I diont know much SQL tho and would appreciate it if anyone could help with this

 

[wh00t]

create the query then go to view menu then select SQL view.