Rounding problem

[chavez_sea]

Hi,
I have a payroll database that also prints the checks. However the check amount for instance 2181.80 is showing up as 2181.8
I rounded the figure, can someone tell me what is wrong.

Aslo I would like to know how to get a report to show up the date other than the normal options. I need the date to show as January 1, 2011 or 1st January, 2011.

Thanks

[ssanfu]

I would use the Format() function on the control(s) in the report or the query .... for both the amount and the date. (see Help)

[pkstormy]

I'm guessing using the format function, it would be something like =Format([MyFieldName],"0,#.##") or something like that (I'm going from memory).

[chavez_sea]

Hi
I tried in the query Net Pay:=Format([Net Pay],"#.##.##") and it gave me the gigures without the 00 if there was not cents. However in addition I need to put ** infron of the numbers eg **1,697.00

Grateful for help.

[ssanfu]

Untested, but try:

= "**" & Format([Net Pay], "##,##0.00")


Note the red above.... 100 will display as 100.00

[chavez_sea]

Thanks you so much. It worked perfectly.

[pkstormy]

Hi
I tried in the query Net Pay:=Format([Net Pay],"#.##.##") and it gave me the gigures without the 00 if there was not cents. However in addition I need to put ** infron of the numbers eg **1,697.00

Grateful for help.

Also - you had format([Net Pay],"#(period)##(period)##") instead of format([Net Pay],"#(comma)##(period)##")