make a table with a memo field. store each chunk of verbage in here one time. include an ID field (Autonumber).
what kinds of calculations are they?
1) if you have ONE resulting calculation: say you will end up with Color = a number. say that a piece of verbage should be output depending on the color range. so then in your table you just made, put two new fields, ColorMin and ColorMax. put in the ranges that apply to each piece of verbage. then in your report, you'd compare your calculated color number to your color range in the table.
2) if you have MORE THAN ONE calculation that will affect which verbage you use, or if one piece of verbage could be output due to more than one combination of calculations, then you'd have a second table. say then you will calculate Color Number and Color Letter. you'd have a table tblVerbageCriteria:
VerbageID ColorNum ColorLetter
1 8 A
1 10 C
2 8 C
2 11 B
see what i mean? for sure have ONE table with unique verbage chunks. then depending on how many calculations are involved, make possibly a second table that houses the ID of the verbage chunk from the first table, and the criteria that will get it selected.
geez i hope i'm at least NEAR the right track here....
g