I have a table with a few hundred records so I am using a paged recordset query to display them. When I do a 'Sum' to display the sum of a column it only displays the sum of the current ones being shown not the sum of the entire query.

Is this a bug or is there some way to get it to show the full total amount, not just what is displayed?

It does not do a sum on your database, it sums only the records returned from the database.