How to sum the table records?

Hi all,

I using the "list" function to extract the sales text delimited file
and insert into the table. How to find out the best sales item and
worst sales item?

item | qty
---------------------------------------
11111 | 2
22222 | 1
33333 | 1
44444 | 1
55555 | 3
22222 | 2
11111 | 1
55555 | 4
22222 | 2
66666 | 1

Thanks

Alex Murphy

.

Relevant Pages

  • Re: How to do an Access Database Query in Excel
    ... This is the Macro I've recorded to do exactly what I manually do to extract ... Before it exports to Excel I wish it to SUM by Location ... each Item sales, so not sure where I would put that in the code below. ...
    (microsoft.public.excel.programming)
  • If Function - Date Problem
    ... particular customer's sales but as individual lines, ... Ultimately I need to extract this info monthly to perform some ... original sales sheet. ... I've looked at pivot tables but they just seem to provide totals. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Extracting Latest Date
    ... >I have a db which stores all my sales transactions. ... >The task is to extract the buy pricefor each itemwhere the ...
    (microsoft.public.sqlserver.mseq)
  • Query Records since last run
    ... I run the same query, I want to extract only records since the last ... Customer Sales Date Sales Value ... I only want to extract records added to the sales table SINCE ...
    (microsoft.public.access.queries)
  • Re: How to sum the table records?
    ... I using the "list" function to extract the sales text delimited file ... I'm sure it's possible in one query, but I'm not familiar enough with JOINS ... That's more of a database question, ...
    (comp.lang.php)