I am trying to use a date entered on an Access Form along with an Employee code to filter a table which is the Record Source for a subform (It is a different table to the Record Source for the Main form). It works fine when the day of the month is 2 digits (ie. 10th of month to end of month), but when I try to enter a date with the day of the month only 1 digit (ie. 1st to the 9th of the month) it does not work, I want to be able to edit and update the details and do a DSUM using the same criteria as the filter.
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Date Filters in Access
I am trying to use a date entered on an Access Form along with an Employee code to filter a table which is the Record Source for a subform (It is a different table to the Record Source for the Main form). It works fine when the day of the month is 2 digits (ie. 10th of month to end of month), but when I try to enter a date with the day of the month only 1 digit (ie. 1st to the 9th of the month) it does not work, I want to be able to edit and update the details and do a DSUM using the same criteria as the filter.