Re: access sql question
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 09/01/04
- Next message: Gary Walter: "Re: Problem with query: SELECT TOP 1"
- Previous message: Ellen: "Append table"
- In reply to: esta: "access sql question"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Sep 2004 08:34:06 -0500
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?
-- Duane Hookom MS Access MVP -- "esta" <esta@discussions.microsoft.com> wrote in message news:C71C5130-39B2-4166-8669-1AAD5C66B0D8@microsoft.com... > 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!
- Next message: Gary Walter: "Re: Problem with query: SELECT TOP 1"
- Previous message: Ellen: "Append table"
- In reply to: esta: "access sql question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
