I’m using C# and Winforms. I’m trying to make a report that gives a list of people that need to renew their memberships if they expire within a user supplied date range. I've got a connection to an Access file, and I'm trying to set up a fill query for a TableAdapter, and I can’t figure out how to put a variable in my "WHERE" clause. The below SQL works to do what I need but obviously I don’t want to hard code the dates. I would like to substitute the dates with the variables “fromDate” and “toDate”. How can I do this? Thanks.

```
SELECT   [Last Name], [First Name], [Renewal Date]
FROM     Members
WHERE    ([Renewal Date] >= #1/1/2000#) AND ([Renewal Date] <= #1/1/2012#)
ORDER BY [Renewal Date]

```