http://office.microsoft.com/en-us/access/HA100963141033.aspx?pid=CH100645771033
That link may help you out... its a tutorial on doing this. Make sure that you have the parameter setup under the currect section - IE The date section.
Also, make sure that you are running the query for a date...