Date Filters in Access

By SJMcD ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums