Comparing with Access

[Jo]

At present I'm using Excel to compare two datasets using
the IF statement, i.e. IF a=b, true, false, but this can
take along time especially if the data is held on two
different sheets.

Can Access be used to do the same thing and if so, would
the calculation be quicker?

 

[John Vinson]

At present I'm using Excel to compare two datasets using
the IF statement, i.e. IF a=b, true, false, but this can
take along time especially if the data is held on two
different sheets.

Can Access be used to do the same thing and if so, would
the calculation be quicker?

As a relational database, this is bread and butter for Access: you'ld
just create a Query joining the two tables. If you'ld care to post
some details of the nature of the data and of the comparison,
including how you'ld like to see the results, we'd be glad to help set
up this query.

And yes... it will be MUCH MUCH faster.