Pass Thru Query - Pass in Parameter

[CT Witter]

I have setup a simple pass thru query and want to pass in a parameter value. I tried using the regular SQL syntax, but it doesn't seem to want to work.

Here is my sql

SELECT 
  ICH.CLAIM_NUMBER, 
  ICH.DATE_RECEIVED
FROM 
  T1.I_C_H ICH
WHERE
  ICH.DATE_RECEIVED >=StartDate AND  ICH.DATE_RECEIVED <=EndDate

I want to specify the dates as coming from a form, ie [Forms]![Form1]![StartDate].

Is this possible??

Thanks,
CT

 

[Ziggy]

Put this in the Criteria line for the date field in your Query design grid


>=[Forms]![Form1]![StartDate] And <= Forms]![Form1]![EndDate]

 

[CT Witter]

I'm not using the query design grid, just straight SQL. SQL won't accept those types of arguments.