Column Report

[Guest]

I have a database of locations with a link to a table of buildings. Each
building has multiple cost fields associated with it. I am trying to generate
a report that has all buildings at a location. I would like to have the
different cost labels on the left hand side and a column for each building
from left to right. Any help would be appreciated.

 

[Duane Hookom]

A crosstab might work. It would help to know more about your table
structures, sample data, and desired final display.

 

[Guest]

I have never worked with a crosstab report i will certainly read up on it.
How would be the best way to show you exaple data and structure? Thank you
for your help.

 

[Duane Hookom]

You simply type in your table names and the important field names:
tblBuildings
==========
BuildingID primarykey Autonumber
BldName
BldAddress

tblOtherTable
==========
otherA
otherB
....

Then a few sample records:

Then your desired end display.