Adding months

  • Thread starter Thread starter Mike Jolley
  • Start date Start date
M

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
 
Mike Jolley said:
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,
Click to expand...

Look in help for the DateAdd() function.
 
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.
 
Sorry, I forgot something in the formula:
NextDue:DateAdd("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]>
Click to expand...
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



.
Click to expand...
.
Click to expand...
 
Back
Top