I have form in Microsoft Access with a date field. Every time I enter a date in the field and click the Print button the "Enter Parameter Value" dialog pops up. This means the date in being entered twice. I want to enter the date in the form and when I click the Print button the report should open up instead of the dialog box. How do I get the date field to be recognized by the procedure the first time without having to enter it again? I believe the project was created in Microsoft Access 2000 but, I'm opening the project in Microsoft Access 2010.
Here is the code in the procedure:
SELECT ISNULL([LEVEL OF SERVICE], 'Total') AS SERVICES, ID AS Total
FROM dbo.Table1
WHERE (servicedate BETWEEN @begin AND @end) AND (servicedate IS NOT NULL)
GROUP BY ISNULL([LEVEL OF SERVICE], 'Total'), ID