Use Parameters to Ask for User Input When Running a Query in Microsoft Access (Parameter Query)

[@MissVisualize]

thank you!!!

[@justloco]

Is there a way to make a parameter query that allows you to pick from a dropdown box?

[@nadiavranken4173]

is it possible to set a parameters on two different fields so you can choose in wich one you search your data. for example one on name and one on city and only fill in one of the two dependent of wich information you want

[@599CD]

Sure. Search Form 2.0: 599cd.com/SearchForm

[@tlims]

Hi, I have been learning a lot from your videos. Thank you! I've got a question and hope to get some answers. I have a report which is based on a parameter query asking users to key in the start date and end date. Embedded in this report is another sub-report that has the same parameter date query but pulling out different data. Users are prompted twice for the start and end date when I run this report. Is there any way I can pass the dates entered by user from the main report to the embedded subreport ? Thank you!

[@599CD]

599cd.com/FormName

[@davidcooke285]

Can you have a default value appear? I use this in my parameter and it works but would like to see the date appear as the default - ">=Nz([Enter Date:],DateAdd("d",-1,Date()))". I know I can do it as a form but wondering if it can be done from the query. Thanks for your videos!

[@599CD]

Not with a simple parameter prompt. You'd need to use a form or input box. 599cd.com/InputBox

[@Bigberg007]

i need help plz, when i enter a name i need to find data for, the query open empty with no data

[@599CD]

Sorry, but based on the information you've given me, I really don't have enough data. Feel free to submit your question with more details (including screen shots) in the Access Forum on my web site. 599cd.com/AF

[@justloco]

Make sure the name you input is exactly as the name in the table

[@DakovP]

ty

[@PRERAKAR]

SHORT AND CRISP TEACHING METHOD. I NEED TO CHANGE THE TITLE " ENTER PARAMETER VALUE" OF THE PARAMETER QUERY DAILOGUE BOX, WITH MY OWN CUSTOMISED TEXT. IS IT POSSIBLE

[@599CD]

599cd.com/QQ

[@nonanice1]

How to ask user to enter dates using IN parameter?

[@599CD]

599cd.com/ask