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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range on Crosstab Query to create a Reports 1
Dynamic Reporting based on Parameterized Crosstab Query 10
How to specify a date range in a cross tab report 2
Creating Report Based on Crosstab Query 3
Attendance report and cross-tab query 3
Date Range on Report 3
Strange Report display problem - XP and Vista - Access 2003 2
Access 2k report based on cross-tab query 3

Back
Top