Indexing Queries

[sr71aa]

Hi folks!

I'm a new user and need a hand. I'm running a query with two tables joined. I have 4 columns: Name, Day of Week, Date, Start Time. I want to create a 5th column that will number each record: 1,2,3,4,etc. I've tried researching help with indexes and primary keys etc. The main reason that I want to do this is to match up the uniques value with another query. The other query is identical with the exception of stop time versus start time. Bottom line is I want to automate a schedule for people but I'm trying to deal with shifts that go from one day into the next and I need a common denominator.

Any help would be appreciated.

 

[nateobot]

Would it work to add a new column called StopTime and record what the stop time was rather than creating and maintaining two tables?

Otherwise you would add an Autonumber field to each table. If you go with this method, however you have to make sure that each row is in the identical sort order before adding that Autonumber field.