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!
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!
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
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
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
Is there a way to make a parameter query that allows you to pick from a dropdown box?
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.com/FormName
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!
Not with a simple parameter prompt. You'd need to use a form or input box. 599cd.com/InputBox
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
Sure. Search Form 2.0: 599cd.com/SearchForm
ty
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.com/QQ
i need help plz, when i enter a name i need to find data for, the query open empty with no data
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
Make sure the name you input is exactly as the name in the table
How to ask user to enter dates using IN parameter?
599cd.com/ask