I have a Microsoft access database that has 13,000 user records. Each user is is assigned an Org_Number...?

Question

I have a Microsoft access database that has 13,000 user records. Each user is is assigned an Org_Number that looks like the following (I.E. 0000_0001, 0000_0002, etc...). In some cases there is only one person with that org_number and they are given the label A. If there are multiple people in an org_number I have to look at their assigned access. If anyone one of those users has different access then the rest the whole group also is labeled B. If the whole group has the same access then they are given the label A. Each users access is held on a seperate table in access. My question is besides going line by line thru 13,000 records what other ways could I process these users and get them labeled? (I.E. Queries, Tables, Forms)???

Answer 1

First make a copy of the table and work with the copy. If you make a misteak then you can delete the copy or delete the original if you are satisfief with the results...

Add a column to the table which will hold your A or B value

Next make an update query which will populate this additional column. You can either make one super update query and try to all the up dates at once OR run several smaller queries which will update portions of the table .

By small query I mean only finding the "A" members for example. Then tweak the query for the "B" members.

Answer 2

- factor & ''factor and TNA rocks(me)" vs Eddie_advocate & Eddie Guerrero = factor and factor and Tna Rocks u are considered one of my superb acquaintances and that i like Ur Questions and answer ur an exceedingly great consumer 2-Masters & John Morrison vs Kennedy & Mr.Kennedy n1 fan. = Masters for specific i'm a Legend interior the making and it is generally an common tournament by using fact mr.kennedy#1fan isn't that elementary by using fact he's my superb pal and he's that damn sturdy 3-Koumidator & Undertaker vs Jayson Kane & Kane = Koumidiator and UnderTaker , koumidiator is between the wonderful answerer in Y!A and that i admire him very lots 4-coronary heart smash Gal & HBK & coronary heart smash Boy vs Randy Orton & RKO for President & Legend Killer % = sorry guy i will't vote i like the three consumers and 3 wrestliers who on it so Tie 5-Ronn & Cm Punk vs Cassidy & Kurt perspective = Ronn he's kewl and he's taken into consideration one of my superb acquaintances ( sorry Cassidy) and for specific i will for ya My Fav wrestlers Morrison,factor,orton and MVP