Subform comparison of 2 tables excluding non zero value

[dboollu]

I am creating a subform (at least that is what I am assuming would be best
choice)(Access 2003/NT) in which the user will type in a Melt# (contained in
the tblChemicalResults). I need to create a side by side comparison of the
chemical requirements from the tblChemicalRequirements to the actual results
contained in the tblChemicalResults, but I need it to exclude any non zero
values from both tables. Each table contains all of the possible 14 different
metal elements that could possibly go into making a particular part.
Obviously, not all 14 go into every part, so how do I display only the
elements that have a non zero value while also displaying the corresponding
Melt# (or possibly #'s)?

ANY help with any portion of this would even be greatly appreciated!

Sadly, I have been trying to figure this our for far more time than I am
willing to admit. I am relatively new to this, so please have patients in my
foolishness as I am sure this is some pretty easy and basic stuff.

Any and all help is greatly appreciated!!!!!

 

[Dale Fye]

Can you show us your table structure (field names) and a couple of rows of
data?

Dale

 

[dboollu]

Sure I'll try...the table structure is as folows:

tblChemicalResults tblChemicalRequirements
Melt# Melt#
AlloySpec
SI SI
FE FE
CU CU
MN MN
CR CR
NI NI
ZN ZN
SN SN
TI TI
BE BE
CO CO
Other Other
Total Total

I don't have any real data at this point, but the data is simply numbers
generated during the process of a machine melting down (where the Melt#
originates) the specified part to perform a chemical analysis of what metal
elements the part contains to be sure it contains the correct contents for
the part. The resulting data would be stored in the ChemicalResults table.
I need to do a side by side comparison of that data in a form (leaving out
any fields that do not contain data returned from the chemical analyse
machine) with the elements contained in the ChemicalRequirements table (which
is specified by the customer).

Does this make sense to you??