Compare two fields in one table to find differences
Hi,
I have an access DB with a table (tblPersDetails) and two fields I need to compare to each other.
tblPersDetails.Rank
tblPersDetails.WornRank
I need to work out when Rank <> WornRank and display the results in a query. Rank is updated manually, WornRank is updated via a data import/update to function.
What is the best way to achieve this ? Ideally I would like this done in a query or the like, but am open to a better way of achieving this.
I have attached a db file (change from .txt to .mdb) with sample data.
Many thanks
db1.txt
I have an access DB with a table (tblPersDetails) and two fields I need to compare to each other.
tblPersDetails.Rank
tblPersDetails.WornRank
I need to work out when Rank <> WornRank and display the results in a query. Rank is updated manually, WornRank is updated via a data import/update to function.
What is the best way to achieve this ? Ideally I would like this done in a query or the like, but am open to a better way of achieving this.
I have attached a db file (change from .txt to .mdb) with sample data.
Many thanks
db1.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thankyou both for the answer. I accepted both solutions as they both worked, but the second one is exactly what I was looking for; however, it was posted 2 minutes after the first.
Cheers