I'm trying to figure out if it's possible to have Access calculate a date field based on the contents of a text field and another date. I have done this with Excel with "If/then/or", easy enough, but haven't been able to figure out if it's possible in Access.
I have 3 possible entries for the text field, CAR, HAZ, PAS.
I'll have a start date that will be entered by the user.
I then want Access to calculate a due date field based either 30 or 45 days out from the user entered date, 30 days out if either HAZ or PAS is in the text field being used, and 45 days out if CAR is in the text field for the record.
Can this be done in Access?
Or, would it be easier to have a number field associated with each text entry above that represents the 3 options, then have the date calculated using the DateAdd() function somehow?
Thanks!
Michael