Column Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
A crosstab might work. It would help to know more about your table
structures, sample data, and desired final display.
 
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.
 
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.
 
Back
Top