trying to using text box as a label

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

Guest

My report is grouped by [Materials]. I'm trying to use a text box to label a
(Sum) of materials used. If [Material] = 'Gravel' then text should read
"tons"... if 'Liquid Asphalt', "galllons" etc etc etc. Can I do this type
of text box??
 
The best solution would be to have a table of materials with a field for
"UnitOfMeasure". Do you have this setup? Can you create this?
 
David# said:
My report is grouped by [Materials]. I'm trying to use a text box to label a
(Sum) of materials used. If [Material] = 'Gravel' then text should read
"tons"... if 'Liquid Asphalt', "galllons" etc etc etc. Can I do this type
of text box??
Click to expand...


Well, yes you can, but it will be increadibly messy.
Instead, you should add a Units field to the Materials
table. Then you can include that field in the report's
record surce query and use it in the report.
 
A little common sense goes a long way - I think i was "asleep at the wheel".
Yes, that's what I'll do - Thanx

Duane Hookom said:
The best solution would be to have a table of materials with a field for
"UnitOfMeasure". Do you have this setup? Can you create this?

--
Duane Hookom
MS Access MVP
--

David# said:
My report is grouped by [Materials]. I'm trying to use a text box to
label a
(Sum) of materials used. If [Material] = 'Gravel' then text should read
"tons"... if 'Liquid Asphalt', "galllons" etc etc etc. Can I do this
type
of text box??
Click to expand...
Click to expand...
 
Marsh,
Have I told you lately that I admire your programming wisdom?

--
Duane Hookom
MS Access MVP
--

Marshall Barton said:
David# said:
My report is grouped by [Materials]. I'm trying to use a text box to
label a
(Sum) of materials used. If [Material] = 'Gravel' then text should read
"tons"... if 'Liquid Asphalt', "galllons" etc etc etc. Can I do this
type
of text box??
Click to expand...


Well, yes you can, but it will be increadibly messy.
Instead, you should add a Units field to the Materials
table. Then you can include that field in the report's
record surce query and use it in the report.
Click to expand...
 
LOL

No, you haven't Duane. I was starting to feel a little
unappreciated, so thanks for the kind words.

Now that I think back, I haven't complemented you on you
insightful replies lately, so I am delinquent in this
department too.
 
Back
Top