I have an access report that has a field that when the value it pulls directly from the table is less than say 25 I want the report to reflect “Less than 25” so 0, 5, 7, 22 would all say “Less than 25” and NOT "0", "5", "7", "22". I would also have similar situations for other value combinations such as between this and that and so on. How do I do this on the report itself? I cannot alter the data (just the report) as it is used in several other locations. I am guessing that I could use some vb code, but I do not know where to begin.

Thanks

I would base this report on on a query and use and IIF() to set these values. Something like:

MyNewFld: iif([myNumberFld] < 25, "Less Than 25", "Equal to or greater than 25")


Make sense?

Thanks, that was the push in the right direction that I was in need of!

Thanks again :)