creating cross tab based on the range of dates I select

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top