You cannot SUM(Sold_1, Sold_2, Sold_3, Sold_4).  You must use syntax similiar
to:

SUM(NZ(Sold_1) + NZ(Sold_2) + NZ(Sold_3) + NZ(Sold_4))

Notice that I have wrapped each of your Sold_# fields in the NZ( ) function.
This is to avoid NULL addition (anything added to a NULL value is NULL).

What is the relationship between the values in the three fields
([Field_Num], [Field2], and [Field_Name])?  When you Group by these three
fields, you will get 1 record for each of the possible combinations of these
values.  If you don't need [Field2] or [Field_Name] remove both of them from
the SELECT and Group By clauses.

HTH
Dale

Kevin:

You can only sum the values of the Sold columns for each unique combination
of the values in the columns in the GROUP BY clause, so unless the columns
field2 and field_name have the same values for each value of field_num you
are going to get separate summations for each set of unique values, which is
probably why you are getting 8 rows returned rather than 1.  You should
remove the other two columns from the query if you want to sum for each value
of field_num.

More fundamentally, I suspect that your table might not be properly
normalized as you have multiple Sold columns.  This is what's known as
'encoding data as column headings'.  Data should only be stored as values at
column positions in rows in tables however.  The solution is to decompose the
table so that there is a single Sold column in a second table which also
includes a foreign key column(s) referencing the primary key column(s) of the
current table.  To sum the Sold column you'd then join the tables on the
keys, group by the field_num column and sum the single Sold column in the new
table.

Ken Sheridan
Stafford, England