Adding months

[Mike Jolley]

Hello,

I am a new access user and have hit a bit of a wall. In
the database I am writing I want to define a period of
time in months, and add it to a short date. This would
seem to be a simple task - but how is the best way to
achieve it?

E.g. Machine Service Schedule = 3 monthly
Last service 24/07/04

I want access to calculate that the Next service is due on
the 24/10/04 and return it into a field

Can anybody help - thanks very much,

Mike

 

[Rick Brandt]

Hello,

I am a new access user and have hit a bit of a wall. In
the database I am writing I want to define a period of
time in months, and add it to a short date. This would
seem to be a simple task - but how is the best way to
achieve it?

E.g. Machine Service Schedule = 3 monthly
Last service 24/07/04

I want access to calculate that the Next service is due on
the 24/10/04 and return it into a field

Can anybody help - thanks very much,

Look in help for the DateAdd() function.

 

[Christine]

Hi,

This might work:

Create a query based on that table and create a new field
in the query which will calculate the 3 months:
NextDue"m", 3,[Last service])

Christine.

 

[Christine]

Sorry, I forgot something in the formula:
NextDueateAdd("m", 3,[Last service])

Ignore my first response.
Christine.

-----Original Message-----
Hi,

This might work:

Create a query based on that table and create a new field
in the query which will calculate the 3 months:
NextDue"m", 3,[Last service])

Christine.

-----Original Message-----
"Mike Jolley" <[email protected]>

wrote
in message due

on

Look in help for the DateAdd() function.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



.

.