Help in autonumber

[pm709]

Hi all.

I have a table: tblCategories with 2 fields: Categories and Page#, where Page# is autonumber.

----------- -------
Categories | Page#
----------- -------
Accessories | 3437
----------- -------
Antennas | 5384
----------- -------

And I have a query with the same fields. When I sort Categories ascending, Page# shows me the
record number that belongs to it, which is logical (above). What I want is that, no matter
the way I sort Categories, the first number in Page# will always be 1 and incrementing; which is
more, I want it to be: 0001, 0002, ...0020 etc. (below).
I've heard some suggestion about using a module, but I'm a newbie, so I'll appreciate any help.
Regards.

----------- -------
Categories | Page#
----------- -------
Accessories | 0001
----------- -------
Antennas | 0002
----------- -------