Question Locked

I want to create a auto populating column in access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to create an auto populating date column in access that takes the date from the field to the left of it and subtracts 60 days from it and then fills its field in with that. I know the basics of Access and I'm usually pretty good at going back to my textbook when I need to figure out how to do something I don't remember off the top of my head but this is one I'm having trouble with. Any help would be much appreciated.

2 replies

by gary.douglas9

#1 Make certain the field [to the left] IS a date field.
#2 (Assuming the field name [to the left] of the calculated date is "curDate") you can populate the calculated field by setting its value to "= me.curDate - 60"

This discussion is closed to new replies.