Query for data at certain time intervals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a query (or mulitple queries) that will allow me to see data
at the start date and then every 6 months. I need to then put this
information into a report. Thanks!
 
I assume you want a month's worth of data every six months.

SELECT [YourTable-1].YourDateField, [Enter report start] AS [Report Start
Date], DatePart("m",[YourDateField]) AS [Month-1], DatePart("m",[Enter report
start]) AS [Month-2]
FROM [YourTable-1]
WHERE ((([YourTable-1].YourDateField)>=[Enter report start]) AND
((DatePart("m",[YourDateField]))=IIf(DatePart("m",[Enter report
start])>6,DatePart("m",[Enter report start])-6,DatePart("m",[Enter report
start])+6) Or (DatePart("m",[YourDateField]))=DatePart("m",[Enter report
start])));
 
Back
Top