Query to display only first record of month

  • Thread starter Thread starter Jeff Clark
  • Start date Start date
J

Jeff Clark

I need to create a query that will display the first
record of each month with in the table. For example

12/2/2003 Shows in query
12/3/2003
1/1/2004 Shows in query
1/3/2004
etc.

Does anyone know how I can do this? This query is only
done on one table.

Thank you
Jeff
 
One method that works would be something like the following

SELECT Min(DateField)
FROM TableName
GROUP BY Format(DateField,"YYYYMM")

If you need other fields then you could use this as a subquery or as a nested query.
 
Back
Top