This is what i have
SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
[Service Due]
In stead of add the month as (30 days), is there a way i can just add a month?
Any help would be appreciated,
Thanks,
Your Pal
James

On Tue, 21 Apr 2009 14:15:01 -0700, James wrote:

> This is what i have
> SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
> [Service Due]
> In stead of add the month as (30 days), is there a way i can just add a month?
> Any help would be appreciated,
> Thanks,
> Your Pal
> James


Look up the DateAdd function in VBA help.

SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
Serviced]) AS [Service Due]

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks fredg you're a real pal!

"fredg" wrote:

> On Tue, 21 Apr 2009 14:15:01 -0700, James wrote:
>
> > This is what i have
> > SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
> > [Service Due]
> > In stead of add the month as (30 days), is there a way i can just add a month?
> > Any help would be appreciated,
> > Thanks,
> > Your Pal
> > James
>
>
> Look up the DateAdd function in VBA help.
>
> SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
> Serviced]) AS [Service Due]
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>