asked on 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
Microsoft AccessVisual Basic ClassicSQL
Last Comment
Kev
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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