var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sum all record except last one entered
im trying to summarize all records except the last one entered.
the output should be "15" (1+2+3+4+5) is this possible?
One thing i tryed is to put in autodate and time and then count them and leaveout the newest one. Well i can't make it work...
Thx for all help
no, with the example you have shown, it is not possible
ok, if i use a colum with autonumber and leave out the highest one? like this:
the output should be:
summirize all records except the one with the highest ID
With your sample data the only possible "solution" is:
This is because (as r937 has already pointed out) your sample data does not offer any way (e.g. a column with a timestamp) to identify the "newest one".
SELECT sum(column001) FROM theTable WHERE column001 <> 6
If you do have a timestamp column, the following could work (not tested)
Edit: Our posts overlapped: modification_date will be your autonumber
WHERE modification_date <> (SELECT max(modification_date) FROM theTable)
ahh super... thx m8 it works like a charm... of course use MAX