comparing data

C

Coach

hi
looking to build a database just holding the following - looks like this
A B C D
t32 3 6 7 4
t45 3 5 9 2
s45 5 4 7 4

etc

how could i compare the data that I selected eg in this case the top and
bottom
to give the following

A B C D
t32 3 6 7 4
s45 5 4 7 4
2 -2 0 0

eg take the top number from the bottom


CHEERS & MERRY CHRISTMAS
 
D

Duane Hookom

It looks like you have a normalization issue. You might have better luck if
your table was like:

tbNormalized
==============
FieldA FieldB FieldC
t32 A 3
t32 B 6
t32 C 7
.....
s45 C 7
s45 D 4
 
Top