I have a recordest that I am trying to use to add the values of a column named NumberofPeople that are specfic to a date. Here is what I have:

SELECT Sum(NumberOfPeople) as TotalPeople
FROM SupperClubReservations
WHERE SupperDate = 'MMColParam'

The variables are:
Name - MMColParam
Defualt Value - 1
Run-time Value - Request.QueryString("SupperDate"

If I change the Default Value to a date it would only give me the totals of the date that I put in the default value instead of the date in the url..

Help is need with this.