Thanks for your reply,
Now getting this error with and without your additional code for totalling columns
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM thenumbers WHERE (date >= "2009-12-01 00:00:00") AND (date <= "2009-12-28 2' at line 1
I am running this offline on WAMPServer with MYSQL Ver 5.1.32 for testing berfore going live
The odd things is that 3 days ago the search form was working but not adding up the totals now I am getting this error
But nothing has been changed or updated on my laptop or WampServer ?