Query to display only first record of month

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
 
J

John Spencer (MVP)

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.
 
Top