Re: Column Report
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 14:20:02 -0500
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.
--
Duane Hookom
MS Access MVP
--
"Edward Jones (Eddie)" <EdwardJonesEddie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:99BA3A77-3BFB-429E-9C4B-78BF74DB5F31@xxxxxxxxxxxxxxxx
>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" wrote:
>
>> A crosstab might work. It would help to know more about your table
>> structures, sample data, and desired final display.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Edward Jones (Eddie)" <EdwardJonesEddie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>> in
>> message news:EAC3456B-9E94-4DA9-87C5-DA80D7BFDB0E@xxxxxxxxxxxxxxxx
>> >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.
>>
>>
>>
.
- References:
- Column Report
- From: Edward Jones (Eddie)
- Re: Column Report
- From: Duane Hookom
- Re: Column Report
- From: Edward Jones (Eddie)
- Column Report
- Prev by Date: Re: How to show "Modified Date" in report footer
- Next by Date: Re: Formatting/Coding a Report...
- Previous by thread: Re: Column Report
- Next by thread: can't even edit my reports
- Index(es):
Relevant Pages
|
