By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Remove Text Qualifier from ONE field

P: n/a
I have a field with a Number data type, Double field size and Auto
decimal places.

The values of this field should have 3 digits to the right of the
decimal place. For example, 123456.123

I have used the following expression in my query to ensure all 3
decimal places show to the right of the decimal,
Expr2:Format([AdminFTE],"0.000")

Is there a way in which I can export comma delimited text files from my
MS Access queries containing the values for this field but WITHOUT the
text qualifier (") around the values for this field, ONLY?

That is, remove the text qualifier from the values of this field only.

Thanks,

Dec 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I believe the Format() function always returns a string but you can use CSng()
or CDbl() functions to coerce it back to a number.

jmarr02s wrote:
>I have a field with a Number data type, Double field size and Auto
decimal places.

The values of this field should have 3 digits to the right of the
decimal place. For example, 123456.123

I have used the following expression in my query to ensure all 3
decimal places show to the right of the decimal,
Expr2:Format([AdminFTE],"0.000")

Is there a way in which I can export comma delimited text files from my
MS Access queries containing the values for this field but WITHOUT the
text qualifier (") around the values for this field, ONLY?

That is, remove the text qualifier from the values of this field only.

Thanks,
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

Dec 6 '06 #2

P: n/a
BTW, if you convert back to a number then any leading and trailing zeros will
go away.

jmarr02s wrote:
>I have a field with a Number data type, Double field size and Auto
decimal places.

The values of this field should have 3 digits to the right of the
decimal place. For example, 123456.123

I have used the following expression in my query to ensure all 3
decimal places show to the right of the decimal,
Expr2:Format([AdminFTE],"0.000")

Is there a way in which I can export comma delimited text files from my
MS Access queries containing the values for this field but WITHOUT the
text qualifier (") around the values for this field, ONLY?

That is, remove the text qualifier from the values of this field only.

Thanks,
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

Dec 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.