By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,478 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

I'm Stumped. Need to update field

P: 1
Let me preface this by saying thank you in advance, I got stuck with a project at work and know next to nothing about Access programming and am trying to fumble through it.

Tables:
Badge
Date_Of_Incident
Description
Code
Comment
Points
Drop Date

Here is what I need.

The Drop Date should be 90 Days from the date of Incident (I've got that working). UNLESS there is another incident in the last 90 days, then it has to be 1 year from the date of incident.
I am lost with respect to the one year date. Any advice would help.
5 Days Ago #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,128
Use the DateAdd() function. Without more details, I can't give you more direction.
5 Days Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.