Can't get .00 to display on report.

[needadvice]

I have a query built on a table. I then have a letter which is produced from the query. In the letter I have a line which includes a field for '[Amount]'. This is a currency field in the table. If the amount does not contain 'cents', it will diplay only the dollar amount without the '.00'.
The user wants this to show. I've tried various formats and changing the field type but nothing worked.
Any ideas?

 

[BanditWk]

Try:

Format([Amount],"$#,###.##&quot

HTH
Roy McCafferty
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"I do this because I know I can and I'm bored at work - no need to send flowers, wine, dinner, or coffee... Just send me a smile to show me that I've helped." ~ Roy McCafferty, seen on a corner in Las Vegas with a sign that said, 'Will work

 

[needadvice]

Close, but no Cigar. Your format displayed $99. Still no zeroes.
The line reads: ="in the amount of" & " " & Format([Amount],"$#,###.##&quot & " " & "as Docketed in Superior"

 

[JohnLowell]

Try this:

The line reads: ="in the amount of " & Format([Amount],"$#,###.00&quot & " as Docketed in Superior"

and also change Decimal Places to 2.

 

[needadvice]

Thanks John,
That did it.