Random number problem

[Wayne1158]

Need to generate a random dollar amount between $1000 and $2000 with the cents on the end. Have the following formula but how do you limit the cents to two numbers and stop the number going below $1000 (Random * 2000) + 1

Also is there a way to format the result so a comma shows at the thousands mark and to put a $ symbol in the result like $1,387.90

[comment]

Try:

Round ( Random * 1000 + 1000 ; 2 )

Make the result type a number. In layout mode, select the field and choose Number... from the format menu. All the formatting options you need are there.

Edited August 17, 2005 by Guest
Removed unnecessary parenthesses

[Wayne1158]

thanks, works great, appreciate the help.