|
Creating Date Parameter Query
Hi, May I ask how to create a parameter query in ms access where a start date and end date is prompt to the user. There is an existing date field in the table. Thanks.
Nyler
Sunday, May 16, 2004
Step 1. Attend School.
Step 2. Learn.
Step 3. ...
Step 4. ......
Step 5. .........
Step 6. Miller Genuine Draft
Step 7. Read Help File
Step 8. ...
Step 9. World Peace
Step X. Profit.
Sunday, May 16, 2004
People these days are such assholes. A man asks a simple question and instead of a straightforward answer he is told to go buy some MGD!
As we all know, Guinness helps the mind work.
Anon to protect the guilty
Monday, May 17, 2004
Investigate the '?' in Access and search Access help for parameterized queries.
Simon Lucy
Monday, May 17, 2004
You would be much better of to ask this question in one of the Microsoft newsgroups. In fact, those newsgroups on ms-access alone answer about 30,000 to 45,000 questions on JUST ms-access alone in one month…..and most questions are answer in less then 1 hour.
However, I will give some advise here!
You likely want to send the results of the query somewhere…(likely a report).
So, my suggestion to NOT use a parameters query..but simply pass a “where” clause to the OpenReprot. So, just build a nice prompt form to get the start/end date..and then the code to launch the report can be:
Dim strWhere as string
strWhere = “YourDateField between #” & format(me!txtStartDate,”mm/dd/yyyy”) & “#” & _
“ and #” & format(me!txtEndDate,”mm/dd/yyyy”) & “#”
Docmd.OpenReport “yourReprot”,acViewpreview,,strWhere
You can see some nice screen shots of some screens that use the above idea here:
http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
Good luck…and if you need a good place for answers…try the Microsoft newsgroups. (a web interface is availing here if you wish).
http://www.microsoft.com/office/community/en-us/default.mspx
Albert D. Kallal
Edmonton, Alberta Canada
Kallal@msn.com
Albert D. Kallal
Monday, May 17, 2004
 Recent Topics
Fog Creek Home
| 
