Hi,

I am using asp / access2000

I have a list of dates (duplicated dates in lots of cases) in an Access table and I want to create a list box in from the dates but only show unique month & year. So if May 2007 appears 4 times in the table I only wish to show it once in the listbox.

How do I do this?

Thanks
Kerry

try this query, of course change it to suit your own first:

SELECT DISTINCT dteDates FROM tblDates ORDER BY dteYear ASC

something like that.

Hi,

I only want to show the month and year once though.

My table has the following list of dates;
01 May 2007
23 May 2007
23 May 2007
05 Jun 2007
17 Jun 2007
23 Jul 2007

So in my list box I want to see

May 2007
Jun 2007
Jul 2007

I hope this makes more sense.

The table is called tbl_Calendar, the date field is called CalDates

Thanks
Kerry

Edited by - benno2805 on 03 Jun 2007 00:13:02