Sum a column - column changes according to number of items on hand

If you want the totals up-to-the-minute, yes.

I don’t use Excel so I don’t know the answer to that.

ok . My table is in an excel spreadsheet that queries my database every minute. I could create another table with those categories and items - but when the original table updates - it needs to update the new table (i create). I am not sure that can happen.

My original table does NOT have totals - like in the excel spreadsheet (query) there are not totals. The whole point of my app was to give totals. But with all those rows, it seems impossible.

I’m afraid I don’t have any suggestions for your setup. :frowning:

ok. Thanks for the help anyway. You always have great suggestions…

1 Like