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)???
2007-04-02
07:47:29
·
2 answers
·
asked by
Ian S
1