Crosstab Report

[SimonPGreen]

Need some help here as I am not sure the best way to accomplish this.

I have a query that generates data as follows:

[PackageNo] [Date] [Amount]
12345 2/3/2007 100.00
12346 12/3/2007 500.00

I would like to report this in the format

[2/3/2007] [12/3/2007]
12345 100.00
12346 500.00
Totals 100.00 500.00

Is a Crosstab report the mechanism to do this? I am also going to need to do some more complex stuff like calculate the week ending that the payment falls into and use that rather that the actual payment date, some conditional formatting depending on payment status and sum at the bottom.

Appreciate any guidance you can give as reporting in Access is pretty new to me.

Regards,

Simon

 

[Crowley16]

yes, you'll need a crosstab to do this.

I suggest making a query to calculate the date first, and then make a crosstab query on top of this new query.


--------------------
Procrastinate Now!

 

[dhookom]

There is a solution for a monthly crosstab report at faq703-5466. You should be able to modify this for daily.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]