Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet FunctionsMaterial  Management | Guestbook  


In the new query view, Select 'Parameters...' under the Query menu.

 

When the Query Parameters window appears, check and select the correct data type from the drop-down listbox.
Click on the OK button.

 

when users run the query, they will be prompted to enter the input to the two parameters.