get 2 distinct columns in Access

[asp_funda]

hi
I'm trying to get distinct values from 2 columns in access. Until now, here's what I've been using

SELECT DISTINCT month FROM myTable

It returns all distinct/unique values of the column month.
But there's another column named year & what I want is to get the distinct value of both month & year. Like, consider the following data in the table:

month   ||  year
------------------
3	||   2000
3	||   2000
3	||   2000
6	||   2000
6	||   2000
4	||   2001
4	||   2001
7	||   2001
5	||   2003
5	||   2003
6	||   2003
3	||   2004

Now, in the above table data, there are 3 instances of 3/2000, 2 instances of 6/2000, 2 instances of 4/2000, 2 instances of 5/2003 & one instance each of 7/2001, 6/2003 & 3/2004.

What I want is to get only the unique entries. These are 2 columns of one table & I want one instance of each occurence.

Can anyone help?

[r937]

select distinct [month], [year] from yourtable

tip: do not use reserved words like MONTH or YEAR to name your columns -- you are only asking for syntax errors

[asp_funda]

select distinct [month], [year] from yourtable

do I put the braces([ ]) too? b'coz without braces, I don't get desired results.

tip: do not use reserved words like MONTH or YEAR to name your columns -- you are only asking for syntax errors

Thanks for the TIP.

[null]

Yup, the brackets are needed...for the reason Rudy brought up..."month" and "year" are keywords in Access...brackets specify a field name, w/out 'em you're selecting keywords, not field names.

[asp_funda]

Oh OK. I got it working. Changed my field names(stupid of me to forget such a common thing, never have done that before, I think I'm getting mad lately, need a vacation ).
Now it works quite well, without the braces.

Thanks Rudy & null.