By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,729 Members | 1,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,729 IT Pros & Developers. It's quick & easy.

Comparing info in 2 tables

P: 1
Good Morning,

I have two Access tables with some of the same categories and I want to compare the information in each table to compare the totals. For instance if I have one table with 1's and 2's and I want to compare it to the other table with 1's and 2's, how can I make the tables position the same numbers side by side for comparison purposes?

Please help! Your assistance would be greatly appreciated.
May 22 '07 #1
Share this Question
Share on Google+
1 Reply

Rabbit
Expert Mod 10K+
P: 12,441
Good Morning,

I have two Access tables with some of the same categories and I want to compare the information in each table to compare the totals. For instance if I have one table with 1's and 2's and I want to compare it to the other table with 1's and 2's, how can I make the tables position the same numbers side by side for comparison purposes?

Please help! Your assistance would be greatly appreciated.
You're probably looking for a join, which join depends on your needs.
Try looking up INNER JOIN and LEFT/RIGHT JOINs
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.