I have 'inherited' a database. In it is a query which looks like a simple Select query but when it is run it produces a table with a bottom line of Totals with the sum of the numbers at the foot of the numeric fields. I would like to do something similar in a database I am working on but I cannot see how the query works. Copying the query into my database and setting a different file produces a table without the totals! Can anyone put me on the right track, please?