I've been experimenting using VBA, which I'm finding has many more options then point and click, obviously! I'm just not sure of the logic necessary to make it look back to the previous Saturday, regardless of what day it is, unless of course, the day the record is entered is a Saturday.

Any help pointing me in the right direction to accomplish this would be greatly appreciated!

David...

I am a relative novice with Access and I am developing an input form that I need a default date to populate, regardless of the input date e.g. If I input data on Tuesday, Sept 27, I want the default date to be the previous Saturday, Sept 23 or if I enter data on Friday, Sept 29, the default date should also be Saturday, Sept 23. Is there a way to do this with date math, since the input date could be any date from the 23rd through the 29th. This...