select month data

[Crosstab report for cross-month data]

I got a question with my report, appreciate some of you can help..

Table contains data fields, a/c no, amount, 'month'.
For data as of Aug, 2009, 'month' will contain...
Jan-09, Feb-09....Jul-09, Aug-09
If next month, 'month' will contain...
Feb-09, Mar-09....Aug-09, Sep-09

How can I make a Form with the above month value changing and allow user to
select more than one month data for a report?

Thanks for your help.

 

[PieterLinden via AccessMonster.com]

I got a question with my report, appreciate some of you can help..

Table contains data fields, a/c no, amount, 'month'.
For data as of Aug, 2009, 'month' will contain...
Jan-09, Feb-09....Jul-09, Aug-09
If next month, 'month' will contain...
Feb-09, Mar-09....Aug-09, Sep-09

How can I make a Form with the above month value changing and allow user to
select more than one month data for a report?

Thanks for your help.

Sounds like you should be able to do it by creating a select query with your
criteria (dynamic) and then creating the crosstab on that dynamic query.