Invoice Details for different months

[fomai]

I currently have a form that contains 2 combo boxes, 1 to select a Director and another to select a Month. This will display their respective projections for that particular month. From here I need to create a report so that when a director selects 'Preview Projections', the report will display 4 months worth of projections. The headings I have for a grid-like report are:

Project, Client, Company, PreviousMonthsFee, CurrentMonthsFee, NextMonthsFee, Next2MonthsFee

I have a query in the report properties to only display the director selected in the form as well as the selected date. I am stumped as to how to bring in the Fee for the other months. Any help would be greatly appreciated.

 

[randysmid]

Hi,
You need to create a crosstab query, and make that query the recordsource of your report.

As an example, let's say that you want a report of salespeople (going down along the left margin) showing their sales by month going across the page from left to right.

Salesperson Jan Feb Mar Apr
Adams 1,000 500 300 0
Brown 3,000 1,000 600
etc.

Each crosstab query needs 3 items:
Row Heading - that would be "salesperson"
Column Heading - the month
Value - the monthly sales amount

HTH,
Randy Smith
California Teachers Association

 

[neillovell]

Thanks for responding