Repeating tables from Create Data Assist pages not working

I just created a DataAssist results page where the repeating table isn't showing all records. I have entered 3 transactions, and have also added a SUM in the recordset to display the total amount raised, which is working.

here is a link to the live page - https://run4fundscolorado.com/sponsor/sponsor-results.php?DetailSchool=Antelope+Ridge+Elementary&Search=Search

Page is zipped and attached if needed.

Thank you for your help.

When using SUM() it automatically combines all rows into one.

The solution is to use a nested SELECT statement. I think it is more efficient to do that in the form of a cross join like:

SELECT sumtable.afrTotal, orderdetails.DetailID, orderdetails.DetailSchool, orderdetails.DetailStudentF, orderdetails.DetailStudentL, orderdetails.DetailPrice FROM orderdetails CROSS JOIN (SELECT SUM(DetailPrice) AS frTotal FROM orderdetails ) AS sumtable ORDER BY DetailStudentL ASC

Ray,

I just noticed that the SUM function is adding the price for all records, not just those meeting the search criteria in the url.

?DetailSchool=Antelope+Ridge+Elementary&Search=Search

Is it possible to use SUM in this way, or do I need to add a second recordset that contains WHERE DetailSchool = 'Antelope Ridge Elementary'

Since you are only showing one Sum on the page, it is probably easiest to just do it in another recordset and filter it with the url parameter like you suggest.