>I see my mistake. Sorry for "my" confusion "again" <g> I was thinking more along the lines of maximum of the table then compare to 99; not individual records.
You can easily get both - either the maximum of field, within a group of grouped records, or the equivalent of max(MyField, 99) or any other number, for an individual record. The latter, with the expression I gave you.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)