Adding Days to a Date Field

[Seahawk0966]

I have a Field called Purchase..

What I need to do is automatically have a Field called Extended that is "Purchase + 180 days"..

I am totally new to Access 2003 and really need some help

 

[KenReay]

Hi

Basically

DateAdd("d",180,Purchase)

Do not add another field to the table, instead, make a query based on your table, with a calculated column it will look like so in the query grid

DueateAdd("d",180,[Purchase])

See DateAdd() function in help for more information

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Seahawk0966]

That works great... thanks for the speedy response...

But what if they want to see it in their form also...

I think the query part will work for some of them but I just want to have my ducks in a row if they ask for it in the form...

 

[KenReay]

Hi

On the form, put a text box, with .controlsource =DateAdd("d",180,[Purchase])


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK