How do you user MS Access date range parameters in the DataAdapter wizzard?

[emaduddeen]

Greeting Everyone,

I am using MS Access in my VB 2008 project.

In the DataAdapter Configuation Wizard I have this query which works fine but I don't know how to change it so I can use the StartDate and the EndDate from a few TextBoxes on my form which is calling a report. The report is based on the query.

Here is the query as it is now:

SELECT        AttendanceID, StudentID, ClassId, DateOfClass, Absent
FROM            Attendance
WHERE        (DateOfClass BETWEEN #5/1/2010# AND #5/30/2010#)

I wish to change the #5/1/2010# and the #5/30/2010# to represent parameters which I will supply to the TableAdapter fill statement.

All help will be greatly appreciated.

Truly,
Emad

 

[jmcilhinney]

You replace the literal values with ? just as you do for any query.

 

[emaduddeen]

Hi,

Thanks for the help.

I used:

WHERE        (DateOfClass BETWEEN ? AND ?)

and it worked.

Truly,
Emad