RE: [AccessDevelopers] formatting text right in query

Thu, 05 Jan 2006 08:33:29 -0800

Thanks you Hossain

Unfortunately this brings up an error, syntax error missing operator in query _expression_.

Sorry my knowledge is poor, I guess this is a simple error or me…

Thanks

matt

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Hossein Taherzadeh
Sent: 05 January 2006 15:49
To: [email protected]
Subject: RE: [AccessDevelopers] formatting text right in query

 

Hello

Try this one:

 

SELECT formatnumber(format(40EXC.Retail),2) as Expr1

FROM 40EXC;

 

 

 

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fastnet Software
Sent: 5. januar 2006 16:37
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