Sorting and Grouping in a Form

[Guest]

Hello,

I have a datasheet form that tracks months. I have a problem. The thing is
the months are tracked by an internal autonumber.

But in my datasheet form my months do not stay in monthly order, Jan, Feb,
and March.

They show up in the datasheet as March, Jan, Feb, which is becasue of the
autonumber. Is there anyway to fix this. Thanks

 

[Joseph Meehan]

Hello,

I have a datasheet form that tracks months. I have a problem. The
thing is the months are tracked by an internal autonumber.

But in my datasheet form my months do not stay in monthly order, Jan,
Feb, and March.

They show up in the datasheet as March, Jan, Feb, which is becasue of
the autonumber. Is there anyway to fix this. Thanks

If I understand what you are doing correctly, the problem is the
autonumber.

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.