access sql question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

could someone give me assistance with this query?
I need to select records from a table where FIELD A in REC 1 is equivalent
to FIELD b in REC2. If fields match I need to combine (sum) numeric fields
in these records and create one "total" record and insert that record into a
new table. I am new to SQL and am having difficulty. I know the GROUP bY
statement will combine like fields, but the fields that I am comparing are
not the same fields. ANy ideas? Thanks!
 
How about providing a couple samples of existing records with table and
field names and then how you would expect them to be appended to a new
table?
 
Back
Top