Question Locked

Date Filters in Access

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can someone help with a problem I have ?

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.

1 reply

This discussion is closed to new replies.