K
Kevin
I am not sure if this is something that can be done in an Access report. (I
may have just got some Access fanatics blood boiling with that phrase!)…But
here is what I’d like to accomplish: I have a report that provides the sum
of estimated labor hours for various categories called “CBDCode†for a
project. There are 13 available records. One of those records is “Customâ€.
I’d like items that contain “Labor.Custom Hours†to display the record
“ItemLabel†and only it’s associated hours.
The report structure is as follows:
CBDCodeID Header – contains fields CBDCodeID(invisible) & CBDCode
ItemLabel Header – contains ItemLabel & RoomName
Detail – contains Quantity & ProductDescription
Where ProductDescription equals the value Labor.Custom Hours, there will be
a numeric value in Quantity. When it exists I would like to display the
value in ItemLabel and RoomName, along with that value in Quantity. That
section of the report would look something like this:
Custom 188 (this is the total)
[ItemLabel] [RoomName] [Quantity]
100-01 Reception 80
105-01 Nurse Station 66
122-02 Lobby 42
For all other categories other than Custom, no detailed breakout is desired.
My thought was to somehow get the quantity of Labor.Custom Hours up into the
ItemLabel Header so it displays in one line just as I have it listed above.
My other thought was a subreport, but I have no experience with those.
I hope my explanation makes sense. I appreciate any suggestions or help! I
can make another report, but it sure would be great if I could get this all
to work on this report.
Thanks!!
may have just got some Access fanatics blood boiling with that phrase!)…But
here is what I’d like to accomplish: I have a report that provides the sum
of estimated labor hours for various categories called “CBDCode†for a
project. There are 13 available records. One of those records is “Customâ€.
I’d like items that contain “Labor.Custom Hours†to display the record
“ItemLabel†and only it’s associated hours.
The report structure is as follows:
CBDCodeID Header – contains fields CBDCodeID(invisible) & CBDCode
ItemLabel Header – contains ItemLabel & RoomName
Detail – contains Quantity & ProductDescription
Where ProductDescription equals the value Labor.Custom Hours, there will be
a numeric value in Quantity. When it exists I would like to display the
value in ItemLabel and RoomName, along with that value in Quantity. That
section of the report would look something like this:
Custom 188 (this is the total)
[ItemLabel] [RoomName] [Quantity]
100-01 Reception 80
105-01 Nurse Station 66
122-02 Lobby 42
For all other categories other than Custom, no detailed breakout is desired.
My thought was to somehow get the quantity of Labor.Custom Hours up into the
ItemLabel Header so it displays in one line just as I have it listed above.
My other thought was a subreport, but I have no experience with those.
I hope my explanation makes sense. I appreciate any suggestions or help! I
can make another report, but it sure would be great if I could get this all
to work on this report.
Thanks!!