Hi All, driving me crazy. I have a query based on a table where I want to show totals in the datasheet view, based on a range of dates. I've done it before but on a newer version of the database, I can get average, maximum etc. to work, but not Sum. I've looked back at the previous version which still works properly and I can't see a difference.
The query has text boxes to ask for the date start/end range, there are records in that range and it finds them. The column that I want totalled is called 'Facttotal' so no naming problems, and the data type is Euro.
As last year's version works and this year's is a copy but without the old data, just the new, I can't figure out what is wrong.
Thanks for any help.
I have to start a new table evry year for local tax authority reasons.