S
scottydel
Hello,
I'm using Access 2003. I have a query that returns a number of fields from
various tables. The query results for example could be:
Jim Green Cleveland
Sue Orange Chicago
Bob Blue Montreal
I would like to add another field to the query that assigns a "record
number" to each record, always starting at 1. Such the query results would
be:
Jim Green Cleveland 1
Sue Orange Chicago 2
Bob Blue Montreal 3
..
..
..
I would like the "record number" to always start with 1. This query gets
run multiple times, with any number of resulting records, and no matter how
many times it's run (results will vary depending on other criteria) ,I'd
still like it to start from 1:
Jim Green Cleveland 1
Sue Orange Chicago 2
Bob Blue Chicago 3
Ed Yellow Shanghai 4
Or if I run the query again:
Tom Black Shanghai 1
Jim Green Cleveland 2
Sue Red Seattle 3
Bob Blue Chicago 4
Angela Red Seattle 5
Sue Green Cleveland 6
Tim Red Seattle 7
Missy Blue Daytona 8
Sue Red Seattle 9
etc...
Seems like something that should be pretty easy, but I don't know how to do
it!
Any ideas?
Thanks,
Scott
I'm using Access 2003. I have a query that returns a number of fields from
various tables. The query results for example could be:
Jim Green Cleveland
Sue Orange Chicago
Bob Blue Montreal
I would like to add another field to the query that assigns a "record
number" to each record, always starting at 1. Such the query results would
be:
Jim Green Cleveland 1
Sue Orange Chicago 2
Bob Blue Montreal 3
..
..
..
I would like the "record number" to always start with 1. This query gets
run multiple times, with any number of resulting records, and no matter how
many times it's run (results will vary depending on other criteria) ,I'd
still like it to start from 1:
Jim Green Cleveland 1
Sue Orange Chicago 2
Bob Blue Chicago 3
Ed Yellow Shanghai 4
Or if I run the query again:
Tom Black Shanghai 1
Jim Green Cleveland 2
Sue Red Seattle 3
Bob Blue Chicago 4
Angela Red Seattle 5
Sue Green Cleveland 6
Tim Red Seattle 7
Missy Blue Daytona 8
Sue Red Seattle 9
etc...
Seems like something that should be pretty easy, but I don't know how to do
it!
Any ideas?
Thanks,
Scott