Sum columns with code?

I

idta

Hi there, I have a table full of numbers. I want to delete all the
columns that do not have ANY numbers in the rows under the column. I
assume I could sum the column, and if the sum is 0, I know there are no
vaules in the column. I then could delete this column and move on to
the next column.

Anybody know the commands to sum the column, and proceed to the next
one (without knowing the name of the next column)? If not, I could
always hardcode the name of the column and loop it, but that would be a
nice feature.

I have a rough idea of how to delete and progress through the table.
But how do I perform a sum?

Thanks.
 
I

idta

Yes, by default there are that many fields for the user to input
information.

I'd prefer to do this via code and not a query because I have many
fields.

Thanks.
 
Top