Prev: Multiple <> query criteria
Next: Trying to update multiple fields in the same record (same tabl
From: scottydont2121 via AccessMonster.com on 16 Apr 2010 08:19
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

From: raskew via AccessMonster.com on 16 Apr 2010 09:11
Hi -

Try playing with this:

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

HTH - Bob

scottydont2121 wrote:
>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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

From: Jerry Whittle on 16 Apr 2010 09:42
Amount: String(9-Len(Format([Award Payment], "00.00")),"0") & Format([Award
Payment], "00.00")
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"scottydont2121 via AccessMonster.com" wrote:

> 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
>
> .
>
From: scottydont2121 via AccessMonster.com on 16 Apr 2010 09:55
Thanks this worked out perfectly.

Thanks for your help

Jerry Whittle wrote:
>Amount: String(9-Len(Format([Award Payment], "00.00")),"0") & Format([Award
>Payment], "00.00")
>> Hello,
>>
>[quoted text clipped - 19 lines]
>>
>> Help Please

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

From: John Spencer on 17 Apr 2010 09:29
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

scottydont2121 via AccessMonster.com wrote:
> 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
>
 | 
Pages: 1
Prev: Multiple <> query criteria
Next: Trying to update multiple fields in the same record (same tabl