by year by month

[pbaldy]

I'm sorry, that's a brain cramp on my part. Format would work on the original date field. For the month integer:



=MonthName([MonthSort])

[nkuebelbeck]

tried that. MonthName is not a valid function in access 97.

[pbaldy]

Presuming the original date field is in the data, you can use the Format() function on that.

[nkuebelbeck]

I am using the monthsort: month([Datefield]) in the query, if i use anything else here i lose the ability to sort by month.

In the report I try to use monthname([Monthsort]) - no dice I get error

I know I could just use a combo box, by that seems over complicated.....

Where did you want me to try to format()?

[pbaldy]

I assume that DateField is still returned by the query, so a textbox in the report:

=Format(DateField, "mmmm")

Since it looks like you may be grouping in the report, if you're already grouping on month an year, you may be able to add a similar field in the query without affecting the result. If not, then another idea is:

=Format(DateSerial(YearSort, MonthSort, 1), "mmmm")

[nkuebelbeck]

little confused. I am using both year() and month() in the query to extract and sort accordingly on one date field. so I can group by year, and by month

[nkuebelbeck]

I just used a combo box and a lookup table. Need to move on