C
christy726
Currently, I use "Sorting and Grouping" tool in the Report Design View
to create group headers so that I can group my data accordingly.
However, I would like to know if I can apply a custom sort order.
For example, the field name that I want to group is "Region". I have
records of "East", "North", "South", and "West". Is there a way that
I can order by "North", "South", "East", and "West" instead? If I use
the "Sorting and Grouping" tool, it won't work because it only accepts
ascending or descending order.
I've heard about the Order By Property function but I'm not quite sure
how to apply in this situation. I'm not good at building events or
macros in Access. So I really appreciate if you can provide me
detailed guidelines.
Thanks for helping me out!
to create group headers so that I can group my data accordingly.
However, I would like to know if I can apply a custom sort order.
For example, the field name that I want to group is "Region". I have
records of "East", "North", "South", and "West". Is there a way that
I can order by "North", "South", "East", and "West" instead? If I use
the "Sorting and Grouping" tool, it won't work because it only accepts
ascending or descending order.
I've heard about the Order By Property function but I'm not quite sure
how to apply in this situation. I'm not good at building events or
macros in Access. So I really appreciate if you can provide me
detailed guidelines.
Thanks for helping me out!