Expression in Sort/Group

[Guest]

I used the expression in the sort/group field:

=Instr(Left([MonthAcquired],3,"JanFebMarAprMayJunJulAugSepOctNovDec")

However, all of my data is grouped under one month (November). How do i get
my months to group data via month acquired as they did b4 i used this
expression, but in calendar order (Jan - Dec).

In my table, the field [monthacquired] is text for a drop down list.

 

[John Spencer]

=Instr(1,"JanFebMarAprMayJunJulAugSepOctNovDec",Left(MonthAcquired],3),3)

 

[Duane Hookom]

Good catch John. I think I had posted the wrong expression a while back.


--
Duane Hookom
MS Access MVP

=Instr(1,"JanFebMarAprMayJunJulAugSepOctNovDec",Left(MonthAcquired],3),3)

I used the expression in the sort/group field:

=Instr(Left([MonthAcquired],3,"JanFebMarAprMayJunJulAugSepOctNovDec")

However, all of my data is grouped under one month (November). How do i
get
my months to group data via month acquired as they did b4 i used this
expression, but in calendar order (Jan - Dec).

In my table, the field [monthacquired] is text for a drop down list.

 

[Guest]

Thank you.

=Instr(1,"JanFebMarAprMayJunJulAugSepOctNovDec",Left(MonthAcquired],3),3)

I used the expression in the sort/group field:

=Instr(Left([MonthAcquired],3,"JanFebMarAprMayJunJulAugSepOctNovDec")

However, all of my data is grouped under one month (November). How do i
get
my months to group data via month acquired as they did b4 i used this
expression, but in calendar order (Jan - Dec).

In my table, the field [monthacquired] is text for a drop down list.