View Single Post
  #14  
Old May 18th, 2010, 09:56 AM posted to microsoft.public.access.queries
Edwinah63
external usenet poster
 
Posts: 16
Default Determining EVERY month between 2 given dates

D'oh! forgot to add the very first query that needs to be run:

SELECT Min([dt]) AS MinDt, Max([dt]) AS MaxDt, DateDiff("m",[mindt],
[maxdt]) AS MaxMths, MonthsBetweenDates([MinDt],[Maxmths]) AS MthsBtwn
FROM Table1
WHERE (((Table1.dt)#5/1/2011#));

:-)