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")
WHERE SupperDate = SupperDate