Search results

I finally figured it out, beginning with your suggestion about the ID number. I exported the names to a new table, then updated the RaceNo field with the ID number for the marathon runners. Runners in the half marathon have numbers that start at 3500, so I just used an update query: [ID]+3499...

That solution would be perfect, except that I already have all the names entered and, worse, the numbering starts at different points, depending on the race: marathon at 1, half marathon at 3500. So, your excellent solution works for the marathon, but what do I do if the numbering has to start...

I'm afraid that I know nothing at all about programming, which suggests that I will need to learn quite a bit more before I can put your good advice to use. Thanks anyway - I just don't know enough to implement a solutoin.

I need to assign race numbers to entrants in a marathon. In Access 2003, I could enter "1" in the Race Number field and then simply press the arrow key; it was a nifty way to assign hundreds of numbers. That feature is gone now. So how do I write a query that will accomplish this?

I am no programmer, and I know just enough about Access to get in trouble. Simple queries - no big problem. But for code, I need help big time, especially when working on the registration database of a marathon I help with.