How can i automatic number for a range of records

[tiger6115]

Hello All,

I am creating an Access 2007 DB and i am wondering what would be the best way to assign an autonumber to a field named Batch# for a range of records. example:

[ID] [FName] [LName] [SSN] [Batch#]
1 Jay Smith 123 00001
..
..
50 Tom Jones 321 00001
51 Lou Clark 231 00002
..
..


100 Sam I'Am 132 00002
101 Joe Toe 213 00003

In essence i need the Batch# to sequentially add 1 for every 50 records.

Any help is appreciated, Thanks in advance.

[pbaldy]

Off the top of my head, this should work in a query:

([ID]\50)+1

[tiger6115]

That worked great. Thanks PBaldy

[pbaldy]

No problemo, and welcome to the site!

[tiger6115]

Thanks for the welcome, I'm loving this site already. I have a quick question. The query is adding +1 on the 50th record, so it breaks down as (1-49, 50-99, 100-149). I have tried changing the 50 in the code to 51 and it breaks down as (1-50, 51-102,...). It's a small thing but is there a way to add +1 after every 50 records? Do I need a count() function? Thanks