distinct month AND year

G

Guest

if i have a table like this:

4/3/2006
4/3/2007
4/12/2006
4/12/2008
5/2/2003
5/5/2003

i would like to extract only the distinct month and year date, so my query
should return

4/12/2006
4/3/2007
4/12/2008
5/5/2003


can anyone plz help me with the sql query? thanks
 
G

Guest

Try this --
SELECT Max(iori.Field1) AS MaxOfField1
FROM iori
GROUP BY Format([Field1],"yyyymm")
ORDER BY Format([Field1],"yyyymm");
 
G

Guest

thanks Karl that works for me :)

KARL DEWEY said:
Try this --
SELECT Max(iori.Field1) AS MaxOfField1
FROM iori
GROUP BY Format([Field1],"yyyymm")
ORDER BY Format([Field1],"yyyymm");


iori said:
if i have a table like this:

4/3/2006
4/3/2007
4/12/2006
4/12/2008
5/2/2003
5/5/2003

i would like to extract only the distinct month and year date, so my query
should return

4/12/2006
4/3/2007
4/12/2008
5/5/2003


can anyone plz help me with the sql query? thanks
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing data in Access 2007 Query 1
Get month between non calendar dates 3
functions in criteria 5
Complex Record Selection 1
12 month rolling average by location 1
query flat file data for most recent data 3
Calculating Headcount by Month 9
Obtain Month & Year from a Text formatted Date field using Left Fu 2

Top