A
Access Rookie
How can I automatically update the End Date to display the create date from a
record previously reported. For example the end date for the first record
listed below should be 9/24/2009 12:41:00 PM and the end date for the third
record listed below should be 8/21/2009 9:00:00 AM.
ID CATEGORY DURATION CREATE_DATE END_DATE
3426 Service 24 months 9/15/2009 9:35:00 AM
3426 Service 24 months 9/24/2009 12:41:00 PM
3426 Service 36 months 8/20/2009 12:23:00 PM
3426 Service 36 months 8/21/2009 9:00:00 AM
record previously reported. For example the end date for the first record
listed below should be 9/24/2009 12:41:00 PM and the end date for the third
record listed below should be 8/21/2009 9:00:00 AM.
ID CATEGORY DURATION CREATE_DATE END_DATE
3426 Service 24 months 9/15/2009 9:35:00 AM
3426 Service 24 months 9/24/2009 12:41:00 PM
3426 Service 36 months 8/20/2009 12:23:00 PM
3426 Service 36 months 8/21/2009 9:00:00 AM