Search results

I did create an automatic numbering field which, as I understand you, I could make into the primary key, But please take a look at a sample of the Tables I am using (uploaded). I would eventually like to create a Unique ID when any one group of values (4) in the MAIN, FROM, TO and SOS fields...

Thanks for responding. Does it matter which field I make the primary key? Once I do that, what next?

Hello, I need some help writing a query. I have a table with street sign information. It has 10 fields. I would like to create a new field (an 11th) and have a new ID number for each unique entry in one of the 10 fields field. In other words, I want to create a new field called UNIQUE...

I admit I am a newbie and I am still using Access 2000, but I hope that means a lot of you will know the answer to this question. I have two tables (one older) with traffic sign information. They each have 8 fields. I want to do something like an Unmatched Query between the fields that define...