RE: [AccessDevelopers] formatting text right in query

Thu, 05 Jan 2006 09:02:18 -0800

Title: Message

Thanks, I have tried rtrim etc and this was as close as I could get -  I wasn’t sure if there was a digit I could put in like #

Thanks anyway

Matt t

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Hoffman, Tobi K (DYS)
Sent: 05 January 2006 15:41
To: [email protected]
Subject: RE: [AccessDevelopers] formatting text right in query

 

Format([Retail],"0.00") will do it, won't lose any digits on the left of the decimal point.

 

Tobi

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fastnet Software
Sent: Thursday, January 05, 2006 10:37 AM
To: [email protected]
Subject: RE: [AccessDevelopers] formatting text right in query

I have now got as far as this

SELECT DISTINCTROW Format([Retail],"0000.00") AS Expr1

FROM 40EXC;

Which produce 0014.99 for example,

Now I need to lose the zeros so that the 14.99 stays right. Any ideas?

Thks

matt

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Fastnet Software
Sent: 05 January 2006 11:23
To: AccessDevelopers
Subject: [AccessDevelopers] formatting text right in query

 

Good day all

Please can someone help with formatting text in a query output/export to a text file?

Basically I have a field on export (I have set up a spec to get field spacings correct) which is all aligned left e.g.

1.00

0

1999.99

I need all the fields right aligned if possible.

Have tried format ‘/3’ e.g. align right, but still exports the same.

Hope I have made myself clear.

Tia

Matt t

 





Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to