Recent content by Mandiab

I have a report that is sorted/grouped by Participant ID and Medical Plan Type. In the report, the visible sections are: Participant ID Header (content of the letter) Details (details on their individual med plans) Participant ID Group Footer (remaining letter details) As the contents of...

Thanks neileg!!! In case anyone wants the code, it's: CCur(Val([MyFieldName]))

It worked Neil you are awesome!!!!!:D

I'm working on a query, it pulls a field that is actually a dollar amount, that looks like any of these examples: 1254.2502ffffffffff 12.25fffff 1200.2351fffffffff 10.02 123.05fffffffff Basically the dollar amount can be anywhere from 1 dollar to a couple of thousand. After the decimal it...