A month selector

[Mark]

Hi all,

I'm needing a option (calendar, combo box, etc) that allows user to select
the month/year. I tried to use the calendar, but couldn't get it to not show
the days. I then tried a combo box looking at the date in my records and used
datepart to extract only the month, then grouped by to get just one
occurrence. This works somewhat, but the month in numeric instead of text.
What is the best was to make a month/year selector?

 

[Noëlla Gabriël]

Hi Mark,

if you want to show the months and years used in a date field in your
database, you can use the format function in stead of the datepart field,
like format([datefield],"MMM-YYYY"). if you include a distinct clause in the
SQL statement that generates the list : select distinct
format([datefield],"MMM-YYYY") from ....
it should give you the desired list