General information
Category:
Coding, syntax & commands
Title:
Adding [sum]med data to an exisiting column(field)
I have a table with numeric values. I would like to sum all the values in one particular column and put the summed value as the next available recno.
Below is an example of what I'm looking to do:
(I.E: I want to sum recno 1 - 4, and put the sum value in recno 5, - summed value would be "30")
(column) Customers
(recno=1) 12
(recno=2) 10
(recno=3) 06
(recno=4) 02
(recno=5)
I would like to have syntax that I can use in the command window if at all possible.
Any help would be appreciated.
Thank you,
Billy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only