I placed the following code on the button that opens the report:

Dim db As DAO.Database

Dim qdef As DAO.QueryDef

Set db = CurrentDb

Set qdef...

Thank you for all of your help. It appears that the forms!f_main!outreach_begin_date variables are not passing the value of the variable to the stored procedure. it is just...

I did not get an error on either select and if i run the execute on sql side with literals it pulls data just fine

for now date string is 5/1/11, 5/31/11 and 5/30/11. i have made variables datetime with same error

when i run an update against the view in sql server the field is updated.

"update viewsocialattendance

set typeofsocial = 'ran to the mall'

where membernumber = '1649' and...

by taking the risk of being presumptuous I was following this article from microsoft.

http://msdn.microsoft.com/en-us/library/ms175521(v=SQL.90).aspx