How do I get Microsoft Access to recognize my date field on my form?

86 views Asked by At

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
0

There are 0 answers