I have a form in Access, where I do "Filter By Form".
No issues there...but I'm being asked to enhance it.
One of the fields is a date field. To search a "Month", I put in
Between #1/1/2011# and #1/31/2011#
To get January 2011.
Can I split the date field textboxes up to 3 fields, and still keep control with a single date filed, while searching by the 3 fields? This way, if I do a "Filter by Form" I can use a textbox or combo box on it?