Adding a Record to the Database Out of Sequential Order

The Access database was created as an indices of
investigative cases, which we wanted to appear in
sequential order by year. However, because a case opened
in 1998 was called 98-001, and a case opened in 2004 was
called 04-001, the 2004 cases were appearing first.
Therefore, we added a "dummy" field to assign numbers
chronologically (i.e. 1 - 2000) so that the cases would
stay in the order they were entered.

However, here is the problem. A case was skipped and
needs to be added. If I insert it at the end of the new
records or through "insert a new record", it is assigned
a "dummy" number, which would be the most recent number
assigned, so the case number itself would be out of
order. I can't figure out how to add a record out of
order without having it automatically appear as the last
entered record, which would make it out of order. I know
I've done it before, but I cannot remember how. Please
help!! Thanks, Lisa

Hi Lisa,

Please see my reply in microsoft.public.access.forms

Rather than posting the same message to more than one group (multiposting)
please cross-post (send the one message to all groups at once). To
Crosspost, put all of the newsgroups into the Newsgroups field in the
message header. In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times.

See http://www.mvps.org/access/netiquette.htm for more information.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Lisa wrote:
The Access database was created as an indices of
investigative cases, which we wanted to appear in
sequential order by year. However, because a case opened
in 1998 was called 98-001, and a case opened in 2004 was
called 04-001, the 2004 cases were appearing first.
Therefore, we added a "dummy" field to assign numbers
chronologically (i.e. 1 - 2000) so that the cases would
stay in the order they were entered.

However, here is the problem. A case was skipped and
needs to be added. If I insert it at the end of the new
records or through "insert a new record", it is assigned
a "dummy" number, which would be the most recent number
assigned, so the case number itself would be out of
order. I can't figure out how to add a record out of
order without having it automatically appear as the last
entered record, which would make it out of order. I know
I've done it before, but I cannot remember how. Please
help!! Thanks, Lisa

Sorry about posting in the duplicate. If I do use the
crosspost which you educated me on in two or more groups,
which group would the post appear under, and where would
I find the responses? I reviewed the netiquette site you
referenced, but it doesn't answer my question. I'm just
a little confused on the cross-post process. Thanks
again.

-----Original Message-----
Hi Lisa,

Please see my reply in microsoft.public.access.forms

Rather than posting the same message to more than one
group (multiposting)
please cross-post (send the one message to all groups at
once). To
Crosspost, put all of the newsgroups into the Newsgroups
field in the
message header. In this way, all responses to your post
will be available
together, regardless of what group the responder was in,
and the rest of us
won't have to read your post multiple times.

See http://www.mvps.org/access/netiquette.htm for more
information.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Lisa wrote:
The Access database was created as an indices of
investigative cases, which we wanted to appear in
sequential order by year. However, because a case
opened
in 1998 was called 98-001, and a case opened in 2004
was
called 04-001, the 2004 cases were appearing first.
Therefore, we added a "dummy" field to assign numbers
chronologically (i.e. 1 - 2000) so that the cases would
stay in the order they were entered.

However, here is the problem. A case was skipped and
needs to be added. If I insert it at the end of the
new
records or through "insert a new record", it is
assigned
a "dummy" number, which would be the most recent number
assigned, so the case number itself would be out of
order. I can't figure out how to add a record out of
order without having it automatically appear as the
last
entered record, which would make it out of order. I
know
I've done it before, but I cannot remember how. Please
help!! Thanks, Lisa


.

Hi Lisa,

I'm happy to try to explain :-)

When you crosspost the message it appears in all of the crosspost newsgroups
so you can check your message thread in any of them. Same with the replies,
they will appear in each of the referenced newsgroups and *generally* it
will show up as read in each of the referenced groups after you've read it
in any of them. The nice thing is that the thread exists only once and you
and all other interested parties can see all the thread activity regardless
of where they first encounter it.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Lisa wrote:
Sorry about posting in the duplicate. If I do use the
crosspost which you educated me on in two or more groups,
which group would the post appear under, and where would
I find the responses? I reviewed the netiquette site you
referenced, but it doesn't answer my question. I'm just
a little confused on the cross-post process. Thanks
again.

-----Original Message-----
Hi Lisa,

Please see my reply in microsoft.public.access.forms

Rather than posting the same message to more than one group
(multiposting) please cross-post (send the one message to all groups
at once). To Crosspost, put all of the newsgroups into the
Newsgroups field in the message header. In this way, all responses
to your post will be available together, regardless of what group
the responder was in, and the rest of us won't have to read your
post multiple times.

See http://www.mvps.org/access/netiquette.htm for more information.


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Lisa wrote:
The Access database was created as an indices of
investigative cases, which we wanted to appear in
sequential order by year. However, because a case opened
in 1998 was called 98-001, and a case opened in 2004 was
called 04-001, the 2004 cases were appearing first.
Therefore, we added a "dummy" field to assign numbers
chronologically (i.e. 1 - 2000) so that the cases would
stay in the order they were entered.

However, here is the problem. A case was skipped and
needs to be added. If I insert it at the end of the new
records or through "insert a new record", it is assigned
a "dummy" number, which would be the most recent number
assigned, so the case number itself would be out of
order. I can't figure out how to add a record out of
order without having it automatically appear as the last
entered record, which would make it out of order. I know
I've done it before, but I cannot remember how. Please
help!! Thanks, Lisa


.