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

[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.

 

[Rick Brandt]

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.

A totals query.

SELECT Sum(YourFieldName) as Whatever FROM YourTableName

 

[John Vinson]

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.

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]