Comparing data

M

Maurice Samueks

Hi, I was wondering is it possible in excess to create a table that in
one column it has some numbers lets say 1-100 then I have another
table that has a random set of numbers I want to combine these tables
side by side visually and for every number that the random generated
numbers had in common with the list of numbers it puts a symbol and
then if it do not match it leaves a blank spot in the table. But I
also want to add as many tables of random numbers side by side as
possible.
 
J

John Vinson

Hi, I was wondering is it possible in excess to create a table that in
one column it has some numbers lets say 1-100 then I have another
table that has a random set of numbers I want to combine these tables
side by side visually and for every number that the random generated
numbers had in common with the list of numbers it puts a symbol and
then if it do not match it leaves a blank spot in the table. But I
also want to add as many tables of random numbers side by side as
possible.
Click to expand...

I have NO idea what you're trying to accomplish.

Having "many tables of random numbers" is going to be extremely bad
design.

Could you explain - rather than *how* you want to do this - *what* you
are trying to do and for what purpose? I'm sure there's an easier way!

John W. Vinson[MVP]
 
M

Maurice Samueks

What I want to do is set up a compare table I am not truthly going to
use random numbers but I will be using numbers. Anyway what I want is
to be able to have side by side comparisons and if they have something
then i want to put somethign in that box if they do not i want the box
left empty if one has something the other one then i want the box
checked for one and vice versa. If that does not help maybe I can aim
you to tell you in more detail.
 
J

John Vinson

What I want to do is set up a compare table I am not truthly going to
use random numbers but I will be using numbers. Anyway what I want is
to be able to have side by side comparisons and if they have something
then i want to put somethign in that box if they do not i want the box
left empty if one has something the other one then i want the box
checked for one and vice versa. If that does not help maybe I can aim
you to tell you in more detail.
Click to expand...

Please do, perhaps with a *REAL LIFE* illustration.

All I see so far is that you're asking for an unlimited number of
two-field tables with no correlation between the fields and
(apparently) no relationship between either field in the table and
anything in the real world. You can certainly set up such a batch of
tables, but I do not understand why you would want to do so, nor what
you will be doing with them.

John W. Vinson[MVP]
 
J

John Vinson

Hey john if you are still interested in helping me I still need your
help. David helped me do it in excel and it works almost flawlessly the
problem now is getting it to work in access because excel just does not
have enough rows. My database is 226000 plus strong. You can take a
look at this thread to see where we have gotten.
http://groups-beta.google.com/group...15868af590b/776166efc0fd591d#776166efc0fd591d
Click to expand...

I looked at that but I'm still baffled.

I *THINK* that this could be done with a very simple query in Access;
your initial message said
by side comparison. I have a large list of numbers and what I want to
do is copy another list of numbers into the spreadsheet. But I want
the numbers in cell A1 and B1 to be equal if they are is not a match
then leave cell b1 empty. I want that to continue all the way through
the entire worksheet. <<

If by two "columns" you mean two one-field Tables, and you want to
find all instances where a value exists in TableA but has no matching
value in TableB, then no code is needed *at all*: just a query

SELECT fieldname
FROM TableA
LEFT JOIN TableB ON TableA.fieldname = TableB.Fieldname
WHERE TableB.fieldname IS NULL

But the thread in the Excel group is still very abstract and it's not
clear what you're working with or why you want to do this, nor what
you will do with the results once you get them.

John W. Vinson[MVP]
 
M

mpsamuels01

ok John if you give me a valid email address I can email you the result
set from excel to see if that helps. What I have is a table that is
considered the master it has over 12,000 six digit numbers. Then I have
another table that have maybe 5,000 6 digit numbers. I want to bring
these two tables together into 2 columns the first table will hold the
12,000 numbers and then the second column displays the list of the
5,000 numbers that were found in the master list.
 
J

John Vinson

ok John if you give me a valid email address I can email you the result
set from excel to see if that helps.
Click to expand...

I'd be willing to do that at my standard consulting rates. That
includes an eight hour minimum, and my rates aren't particularly
cheap.
What I have is a table that is
considered the master it has over 12,000 six digit numbers. Then I have
another table that have maybe 5,000 6 digit numbers. I want to bring
these two tables together into 2 columns the first table will hold the
12,000 numbers and then the second column displays the list of the
5,000 numbers that were found in the master list.
Click to expand...

TRIVIALLY easy, using a query. (One of the advantages of a relational
database over a spreadsheet!)

You have two tables, MASTER and OTHER.

Create a query, joining the two tables on this field.

Select the JOIN line and choose Option 2 - "Show all records in MASTER
and matching records in OTHER".

Select the two fields, one from each table.

Open the query; you'll see all rows in MASTER and, if they had a match
in OTHER, the value of the match; the second column will contain a
NULL if there was no match.

John W. Vinson[MVP]
 
Top