Rules are based on record number
Thanks for answering so quickly. There are 'rules' but not in the traditional sense of the word. The rules are based on record number. The first record in the report will always have no decimal places and need a comma in the thousands. The second record of the report will always need three decimal places
As I am writing this, I think you have absolutely come up with the solution. I will add a third field to the table which will determine how the number in the second field is displayed. If the third field entry is 'thousands', I will display the number as thousands, with no decimal places. If the third field entry is 'threedec', I will display the second field with three decimal places. I think that will work very nicely.
Do you have a better idea?