creating cross tab based on the range of dates I select

[Guest]

Allen , thanks for the step wise explanation for creating a crosstab.
but Allen, I want to create a crosstab query dynamically based on the range
of dates I select in the frmReports form.( which has From Date and To Date)
say, suppose I select 13-7-2006 in From Date and 20-7-2006 in To Date, then
the Attendance report should be generated for these dates only for all the
employees.

 

[Duane Hookom]

You didn't suggest what you tried or what error you might have generated.
Perhaps you only need to declare the data types of your Query->Parameters.