Add by months

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
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
Click to expand...


Look up the DateAdd function in VBA help.

SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
Serviced]) AS [Service Due]
 
Thanks fredg you're a real pal!

fredg said:
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
Click to expand...


Look up the DateAdd function in VBA help.

SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
Serviced]) AS [Service Due]
Click to expand...
 
Back
Top