Column Report

  • Thread starter Edward Jones (Eddie)
  • Start date
E

Edward Jones (Eddie)

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.
 
D

Duane Hookom

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

Edward Jones (Eddie)

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.
 
D

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.
 
Top