Report Control Source

[cmac]

Not sure if this is the correct approach but the end result that I am looking
for in a report is for values contained in month 1 through 12 (values in a
month field) are displayed for each project record.

The source of the data is a table that pulls in actuals transactions from an
Excel ss - multiple transactions per month per project. I have created a
query that sums the transactions by month by project so that the results are
for each project with data are as below:

Project # Month Value
12345 1 350.00
12345 2 650.00
12345 5 400.00
etc.

I now need to display results for a single project as follows:

Project # Month 1 Month 2 Month 3 Month 4 Month 5 etc.
12345 350.00 650.00 0 0 400.00 etc.

Can I repeat the month field from the query used above in a report and add a
statement as a control source for each of the fields - something like a where
or if statement? If so, can you provide help on the proper statement and if
this is the worng direction, provide some new direction?

Thanks!

 

[Marshall Barton]

Not sure if this is the correct approach but the end result that I am looking
for in a report is for values contained in month 1 through 12 (values in a
month field) are displayed for each project record.

The source of the data is a table that pulls in actuals transactions from an
Excel ss - multiple transactions per month per project. I have created a
query that sums the transactions by month by project so that the results are
for each project with data are as below:

Project # Month Value
12345 1 350.00
12345 2 650.00
12345 5 400.00
etc.

I now need to display results for a single project as follows:

Project # Month 1 Month 2 Month 3 Month 4 Month 5 etc.
12345 350.00 650.00 0 0 400.00 etc.

Can I repeat the month field from the query used above in a report and add a
statement as a control source for each of the fields - something like a where
or if statement? If so, can you provide help on the proper statement and if
this is the worng direction, provide some new direction?

Not sure I followed all that, but what you want looks like
you want to use a cross tab query. To get all 12 months
even if a project does not have any tranactions in some
month, set the query's ColumnHeadings property to the list
of months: 1,2,3,4,5,6,7,8,9,10,11,12