MS Access Auto Date Question

Question

I'm using Access to keep track of hours worked, somewhat like a time sheet. So I want to have a "Work Date" column which auto-fills with the next date on each line. In other words, every record will have a new date which is just one day after the date of the previous record.

This would be like the date equivalent of auto-numbering. I have entered the dates below manually, but the idea is that the dates would be auto-filled with each new record.

Please let me know if there is any way to do this.

Thanks!

Answer 1

You can't do this in the table. That's why the DMax is not working. You should never work directly in tables. You should create a form to interface with your table as I instructed. Then set the Default value of the WorkDate control as indicated.

Answer 2

As I wrote, you can't do it in the table. Use the textbox in your form that edits the data.

And now that you have modified the table and field names, the expression will be:

=DateAdd("d",1,DMax("[WorkDate]","[DailyLog]"))

Answer 3

DMax can't possible fail in this context, so something else must be going on.

Answer 4

GustavBrock, thanks a lot for the reply!

I can't get the dmax() function to work. Is there any other way to pull the max date from the [Work Date] field?

Thank you.

Answer 5

You can't do that in the table.

But in the form, you use to edit the data, specify the Default Value for the textbox bound to Work Date to:

=DateAdd("d",1,DMax("[Work Date]","[Daily Log]"))