The values are 140.00, 50.00, etc. The field will take up to 999,999.99 because the non multiplied field is the same size and that is the format string.



>Peter,
>
>Since you are multiplying, your results are probably larger than the box you have put on the report. When the box is too small, you get stars, no matter the display mask, decimals or anything else.
>
>Enlarge the box. Examine the cursor created by your SQL Select to see what types of results you are getting and how much space you can eventually settle on.
>
>>I have a field on my report that displays an amount... I am having difficulty getting the format output to be the way that I want...
>>
>>What I would like is the amount, 2 decimal places, with a floating dollar sign before it.
>>
>>My was set for NUMERIC and the format string was $$$$,$$9.99. This worked fine when I was printing the field from the database file. Now that it is either the field from the file or the result of the field times another field (time*rate) which is stored AS in the cursor, I get ********* for the printout.
>>
>>If I remove the format string entirely, I get the appropriate value (minus the $). If I set it for NUMERIC and CURRENCY, which puts in a @$ for the format, the amount of 140.00 shows as $140.00, the amount of 65.00 shows as $65.000.
>>
>>I checked the settings according to the "regional" for currency and that seems to be correct. Am I missing something or does it have to do with the AS in the SELECT statement that stores the result in a variable in the cursor. Should I predeclare that cursor variable somewhere, somehow as a currency amount?
>>
>>Thanks