MS Access date formula

[oldBastard]

Ok, so this is for the missus I'm posting this.

DATE SUBSCRIPTIONS NEW DATE
01/01/2008 12 Months ?????

What formula do she use to make the new date? Subscriptions can 12/24/36 months. Hope this helps. Do not know MS access at all.

 

[semaphore]

Sorry but your post/question makes no sense. Can you be a bit more descriptive? on what she is trying to achieve?

 

[oldBastard]

Ok, need to create fields where the data capturer fills in the date & how long subscriptions the customer wants, wether the subscription is 1 - 36 months. Then a date must appear on the form when the subscriprion ends.

I don't know of a formula that can work out the date, day/month/year, when the subscription ends.

 

[ant101]

You need to read the help on ms access which contains worked examples of date calculations. Press F1 and search "date calculations"

You most likely need to set the new field to something like :
= [Date] + 365
you can also add months only, but you need to check up in the help for the correct syntax format, if I remember I think it might be something like:
= [Date] + */1/*

Start with a small calculation until you get things working then you can build on that. You can also test it out in ms exel which uses many of the same calculations and expressions, except that you use cell codes instead of field names, [A1] vs [Date]

F1 is your best friend in ms access, unfortunately a lot of people switch off immediately when you tell them to read the help. But trust me, I've learnt many a neat trick by reading the help.

 

[ernstn]

I amm sure Access uses VB, so there should be a DATEADD function.

 

[oldBastard]

Thnx relayed the message