I am trying to get the sum of all people that have a reservation to an event by the date thats in the url. Below is what I have but I only get sum of all records. I am using Dreamweaver, so the 2nd SupperDate is a MMColParam.

Here is what the Variables look like

Name Default Value Run-Time Value
MMColParam 1 Request.QueryString("SupperDate")

SELECT Sum(NumberOfPeople)
FROM SupperClubReservations
WHERE SupperDate = SupperDate