sum a field

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I have a table which has Id, Desc, Num,Qty. This table is
updated with CSV files and files may have the same Id,
Desc and Num but a different Qty. So id and Desc might
repeat itself in the table. Now I need to create another
table that finds repetition of Desc fields and sums qty
and create a single row for it in the new table.
How can I do that?
Thanks,
Jim.
 
To Jim

(e-mail address removed)-net.ne.jp
I have a table which has Id, Desc, Num,Qty. This table is
updated with CSV files and files may have the same Id,
Desc and Num but a different Qty. So id and Desc might
repeat itself in the table. Now I need to create another
table that finds repetition of Desc fields and sums qty
and create a single row for it in the new table.
How can I do that?
Thanks,
Jim.
Click to expand...

"HILL STREET BLUES" Daniel Travanty is the "KEY".
 
Hello,
I have a table which has Id, Desc, Num,Qty. This table is
updated with CSV files and files may have the same Id,
Desc and Num but a different Qty. So id and Desc might
repeat itself in the table. Now I need to create another
table that finds repetition of Desc fields and sums qty
and create a single row for it in the new table.
How can I do that?
Thanks,
Jim.
Click to expand...

Create a Totals query based on the imported (or linked, might be
simpler) text file; to do so, click the Greek Sigma icon (looks like a
sideways M). Group By ID, Desc, and Num, and choose Sum as the totals
function for Qty.

Save this query, and base a MakeTable query on it to create the new
table. I'd actually suggest creating your destination table first,
empty, so you can control the field sizes and formats, and use an
Append query, but if it's a one-time operation a MakeTable will work.
 
Back
Top