Append? Update? Start over?

  • Thread starter Thread starter Danu
  • Start date Start date
D

Danu

I have a table with a tag number field, remaining field, completed field, and
area field.

TAG COMP REMAIN AREA

19 200 6
15 28 8
19 6 6
55 20 12

How would I get the table to look like this:

TAG COMP REMAIN AREA

19 200 6 6
15 28 8
55 20 12

I need to include all tags whether or not they have a related COMPLETED or
REMAINING field.

Thank you.
 
This looks like a simple totals query:

SELECT TAG, Sum(COMP) as COMPSum, Sum(REMAIN) as REMAINSum, SUM(AREA) as
AREASum
FORM [table with no name]
GROUP BY TAG;
 
Thank you. Exactly what I needed!

Duane Hookom said:
This looks like a simple totals query:

SELECT TAG, Sum(COMP) as COMPSum, Sum(REMAIN) as REMAINSum, SUM(AREA) as
AREASum
FORM [table with no name]
GROUP BY TAG;

--
Duane Hookom
Microsoft Access MVP


Danu said:
I have a table with a tag number field, remaining field, completed field, and
area field.

TAG COMP REMAIN AREA

19 200 6
15 28 8
19 6 6
55 20 12

How would I get the table to look like this:

TAG COMP REMAIN AREA

19 200 6 6
15 28 8
55 20 12

I need to include all tags whether or not they have a related COMPLETED or
REMAINING field.

Thank you.
Click to expand...
Click to expand...
 
Back
Top