I have 157 lines w prices in each row.Howwould I create a sum 4it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

having 157 lines with prices in each line row d what kind of program can I
put together to get the full SUM.

PLEASE Assit I need to crunch these numbers before month end.
 
EXEL said:
having 157 lines with prices in each line row d what kind of program
can I put together to get the full SUM.

PLEASE Assit I need to crunch these numbers before month end.
Click to expand...

A totals query.

SELECT Sum(YourFieldName) as Whatever FROM YourTableName
 
having 157 lines with prices in each line row d what kind of program can I
put together to get the full SUM.

PLEASE Assit I need to crunch these numbers before month end.
Click to expand...

If this is (as your assumed name suggests) an Excel spreadsheet
(rather than an Access database table, the subject of this newsgroup)
then you should ask your question in an Excel newsgroup. Scroll down
the list.

Or... just use the Sum operator from the Excel toolbar in the field
where you want the sum.

John W. Vinson[MVP]
 
Back
Top