If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date filter
Sorry, that was wrong, it will prompt a second time. Instead use:
Select * from tblSchedule Where DateField Between Forms!Schedule![BeginDate] And Forms!Schedule![EndDate]; and make sure you change the names of the table and date field to match yours. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Arvin Meyer [MVP]" wrote in message news:... Base your form on a query, instead of a table. The query should look like: Select * from tblSchedule Where DateField Between Forms!Schedule![Enter BeginDate] And Forms!Schedule![Enter EndDate]; -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Chris75" u54211@uwe wrote in message news:9b00b5bee3c34@uwe... Hello, I've gone through various articles and posts to try to figure this out...with no success. I am using Access 2007. Okay. I have a form, with the requisite unbound text boxes for Begin Date and End Date (BeginDate and EndDate). What I obviously want to do is filter my records based on those 2 controls. Here's where I am unclear. I have read about the WHERE query and the sFilter Code. Do I do both or one or should I just write a macro filter, which is something I have not done at all? My form is called Schedule. Thanks for your help. Chris |
Thread Tools | |
Display Modes | |
|
|