Automatic date

[vanstuurwiel]

Hi there,

I am new to this forum and hope that someone will be able to help me.

We have designed a database that has a field called " Date Completed"

What we need is another field that would automatically add 730 Days to "Date Completed" and display the results in a field called "Expiry Date"

Can anybody help with this?

We have tried numerous things ourselves without success.



Thanks

[Desstro]

I am wondering the same question I think.

I have a table with the fields:
MT2AuditDate and
MT2NextAuditDue.

When an AuditDate is entered I want the table to auto date the NextAuditDue field with a date that is 90 days in the future.

I have tried to enter [MT2AuditDate]+90 in the default value of the NextAuditDue field. Did not work.

I will keep trying different things and If I come up with an answer I will be sure to let you know.

I will keep checking in to see if someone else solves our riddle.

[vanstuurwiel]

Thanks a lot

[RuralGuy]

You both need to look at the DateAdd() function in VBA help. Keep in mind that you should *not* be storing this calculated value but simply creating it each time in a query.

[vanstuurwiel]

You both need to look at the DateAdd() function in VBA help. Keep in mind that you should *not* be storing this calculated value but simply creating it each time in a query.

Thank you. Is there any help for someone with NO VBA experience?

[RuralGuy]

The real power of Access is in Queries and VBA. To not have these as tools to use is turning your back on greater than 50% of the features. Have you ever downloaded a database or opened the Example db that ships with Access and looked at and tried to understand any code that it contained? Crystal has a pretty complete site for learning. http://www.accessmvp.com/strive4peace/
There are also tons of helpers on these Forums that can assist with an issue if you get stuck. We're not here to do the work but just give a shove in the right direction.