Decimals

[scottydont2121 via AccessMonster.com]

Hello,

I am making a query for an output file.

I have an amount on my input table and then i want to query it out to look a
particular way.

What i have build in the query looks like below:

Amount: Right("000000000" & [Input File]![Award Payment],9)

The award payment field is the amount.

Only problem is that I need it to look like below:

000040.00 when it outputs.

Currently i have it looking like : 000000040

For my original input table the field Award Payment is set to a currency
field.

Help Please

 

[raskew via AccessMonster.com]

Hi -

Try playing with this:

x = 40
? format(x, "000000.00")
000040.00

HTH - Bob

Hello,

I am making a query for an output file.

I have an amount on my input table and then i want to query it out to look a
particular way.

What i have build in the query looks like below:

Amount: Right("000000000" & [Input File]![Award Payment],9)

The award payment field is the amount.

Only problem is that I need it to look like below:

000040.00 when it outputs.

Currently i have it looking like : 000000040

For my original input table the field Award Payment is set to a currency
field.

Help Please

 

[Jerry Whittle]

Amount: String(9-Len(Format([Award Payment], "00.00")),"0") & Format([Award
Payment], "00.00")

 

[scottydont2121 via AccessMonster.com]

Thanks this worked out perfectly.

Thanks for your help

Amount: String(9-Len(Format([Award Payment], "00.00")),"0") & Format([Award
Payment], "00.00")

Hello,

[quoted text clipped - 19 lines]

Help Please

 

[John Spencer]

If I understand what you want then you should be able to use
Amount: Format([AwardPayment],"000000.00")
That returns
000040.00 for 40
000004.00 for 4
000000.40 for .4
000000.04 for .04
000000.04 for .04444
000000.05 for .0451

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County