How can I make this report look like a table?

[keun]

I have a report which displays four pieces of information:
Contract
Fund
Bidder
Bid.

Each contract has multiple funds, each fund has multiple bidders, and each bidder has one bid.

I would like to lay out the data for each Contract in a table with Bidder in the Y axis, Fund across the X axis, and the Bids populated at the appropriate intersection of X and Y.

I this possible?

 

[keun]

I realize that what I am after is a way to print the output of PivotTable.

 

[dhookom]

The Crosstab sample download at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

provides a solution for reporting a crosstab query where the generated column headings might not be known.

Duane
Hook'D on Access
MS Access MVP