Columns and Rows in Report

[agates]

I have an account list with deposits made on Week Ending dates, 4 or 5 different weeks need to show up on the report, but I want them in columns. Example below:

Name _ 01/01/05 01/07/05
ABC __ $100.00 $25.00
XYZ __ $50.00 $35.00

These dates change every month, of course. I need to know what input to setup on the form and how to set the report up to reflect this in columns. The dates along the top with the company names down the side.

 

[Pat Hartman]

Use a crosstab query. Since the columns will be variable, you'll need to write a lot of code for the report to handle that. There is a sample in the solutions database. You should find a link to it here:
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=172177#post172177