jdluc

I am trying to combine 3 records with the same id_#, either in the same table or in different tables, which ever way is more convenient.

What would a query look like like to do this?

Well, I'm a bit confused as to what you are looking for. But I'll go out on a limb and try something here. Let's say you had a table with 3 columns - id,number1,number2. And you have 3 rows in that table all with the same id of 3 but different number1 and number2's...you could write the following query that would pull back the sum of the number1 and number2 columns:

SELECT SUM(number1), SUM(number2) FROM table WHERE id = 3;

Hope that answers your questions, if not...please elaborate...