By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 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.
Apr 17 '19 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,284
Use the DateAdd() function. Without more details, I can't give you more direction.
Apr 17 '19 #2

Post your reply

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