Re: number sequence
- From: "Lynn Trapp" <ltrapp_NOSPAM@xxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 3 Nov 2005 08:34:43 -0600
Can you post a sample of your data?
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
"lynn atkinson" <lynnatkinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A226463B-764B-4F96-8416-3184F5132E04@xxxxxxxxxxxxxxxx
>I have a table which holds employee id and candidate numbers. However, some
> of the candidate numbers are blank and I would like to fill these in with
> sequential numbers. I have 459 blanks and I dont want to input 1 to 459
> manually. Is there a way of doing this with a formula or a query? It
> doesnt
> really matter what order they go in as they are temporary numbers till the
> real candidate numbers come through. I dont want a permanent autonumber
> here
> either as the numbers will be entered manually when we get them.
> Any ideas
.
- Prev by Date: Re: extra table required?
- Next by Date: Re: How do I show hours and minutes in a time card i.e.: 40:32 weekly
- Previous by thread: Re: extra table required?
- Next by thread: Re: extra table required
- Index(es):
Relevant Pages
|
