Export Limitation

J

JuLee

I am trying to export to a delimited text file. All field
are exporting as they should say for the value field. I am
being limited to two places to the right of the decimal. I
have tried a formatted export query and it is still being
limited. My formatted query is listed below. Does anyone
have any suggestions?

Formatted export query:
( The field I am having troubles with is the value field)
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
Code: 
,"00000") AS code2, [RESULT].[ltGt], Format([RESULT].
[value],"###.0000") FROM RESULT;
 
J

John Nurick

Hi JuLee,

You didn't include an alias for the value field:

SELECT [RESULT].[tag],
Format([RESULT].[date],"mm/dd/yyyy") AS date2,
Format([RESULT].
Code: 
,"00000") AS code2,
[RESULT].[ltGt],
Format([RESULT].[value],"###.0000") AS value2
FROM RESULT;


[QUOTE]
I am trying to export to a delimited text file. All field
are exporting as they should say for the value field. I am
being limited to two places to the right of the decimal. I
have tried a formatted export query and it is still being
limited. My formatted query is listed below. Does anyone
have any suggestions?

Formatted export query:
( The field I am having troubles with is the value field)
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
[code],"00000") AS code2, [RESULT].[ltGt], Format([RESULT].
[value],"###.0000") FROM RESULT;[/QUOTE]
 
G

Guest

John,
Here is the query. I left off the alias when I copied the
query.
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
Code: 
,"00000") AS code2, [RESULT].[ltGt], Format([RESULT].
[value],"###.0000") AS value2, [RESULT].[Extra Field]
FROM RESULT;

Do you have any other suggestions? Thanks for your help!
[QUOTE]
-----Original Message-----
Hi JuLee,

You didn't include an alias for the value field:

SELECT [RESULT].[tag],
Format([RESULT].[date],"mm/dd/yyyy") AS date2,
Format([RESULT].[code],"00000") AS code2,
[RESULT].[ltGt],
Format([RESULT].[value],"###.0000") AS value2
FROM RESULT;


[QUOTE]
I am trying to export to a delimited text file. All field
are exporting as they should say for the value field. I am
being limited to two places to the right of the decimal. I
have tried a formatted export query and it is still being
limited. My formatted query is listed below. Does anyone
have any suggestions?

Formatted export query:
( The field I am having troubles with is the value field)
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
[code],"00000") AS code2, [RESULT].[ltGt], Format ([RESULT].
[value],"###.0000") FROM RESULT;[/QUOTE]

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
[/QUOTE]
 
J

John Nurick

JuLee,

Expressions like this always seem to work for me. The one thing that
looks odd is the format string "###.0000", because in my experience the
Access query design grid does its best to change this to "#.0000", which
has exactly the same effect.

One troubleshooting thing to try: change "###.0000" in the query to "$"
and export it. The exported value2 field should now just contain dollar
signs.

Another thing to check: is there a schema.ini file in the destination
folder? If there is, and it contains a section for this query, it may be
interfering with the settings.





John,
Here is the query. I left off the alias when I copied the
query.
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
Code: 
,"00000") AS code2, [RESULT].[ltGt], Format([RESULT].
[value],"###.0000") AS value2, [RESULT].[Extra Field]
FROM RESULT;

Do you have any other suggestions? Thanks for your help!
[QUOTE]
-----Original Message-----
Hi JuLee,

You didn't include an alias for the value field:

SELECT [RESULT].[tag],
Format([RESULT].[date],"mm/dd/yyyy") AS date2,
Format([RESULT].[code],"00000") AS code2,
[RESULT].[ltGt],
Format([RESULT].[value],"###.0000") AS value2
FROM RESULT;


[QUOTE]
I am trying to export to a delimited text file. All field
are exporting as they should say for the value field. I am
being limited to two places to the right of the decimal. I
have tried a formatted export query and it is still being
limited. My formatted query is listed below. Does anyone
have any suggestions?

Formatted export query:
( The field I am having troubles with is the value field)
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
[code],"00000") AS code2, [RESULT].[ltGt], Format ([RESULT].
[value],"###.0000") FROM RESULT;[/QUOTE]

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
[/QUOTE][/QUOTE]
Click to expand...
 
G

Guest

John,
Thank you for your help.
-----Original Message-----
JuLee,

Expressions like this always seem to work for me. The one thing that
looks odd is the format string "###.0000", because in my experience the
Access query design grid does its best to change this to "#.0000", which
has exactly the same effect.

One troubleshooting thing to try: change "###.0000" in the query to "$"
and export it. The exported value2 field should now just contain dollar
signs.

Another thing to check: is there a schema.ini file in the destination
folder? If there is, and it contains a section for this query, it may be
interfering with the settings.





John,
Here is the query. I left off the alias when I copied the
query.
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
Code: 
,"00000") AS code2, [RESULT].[ltGt], Format ([RESULT].
[value],"###.0000") AS value2, [RESULT].[Extra Field]
FROM RESULT;

Do you have any other suggestions? Thanks for your help!
[QUOTE]
-----Original Message-----
Hi JuLee,

You didn't include an alias for the value field:

SELECT [RESULT].[tag],
Format([RESULT].[date],"mm/dd/yyyy") AS date2,
Format([RESULT].[code],"00000") AS code2,
[RESULT].[ltGt],
Format([RESULT].[value],"###.0000") AS value2
FROM RESULT;


On Tue, 1 Jun 2004 10:16:45 -0700, "JuLee"

I am trying to export to a delimited text file. All field
are exporting as they should say for the value field.[/QUOTE] I
am[QUOTE]
being limited to two places to the right of the[/QUOTE] decimal.
I[QUOTE]
have tried a formatted export query and it is still being
limited. My formatted query is listed below. Does anyone
have any suggestions?

Formatted export query:
( The field I am having troubles with is the value field)
SELECT [RESULT].[tag], Format([RESULT].
[date],"mm/dd/yyyy") AS date2, Format([RESULT].
[code],"00000") AS code2, [RESULT].[ltGt], Format ([RESULT].
[value],"###.0000") FROM RESULT;

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
[/QUOTE][/QUOTE]

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
[/QUOTE]
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format Incorrect on Export 1
How do I keep leading zeros and remove the decimal point when expo 2
Number does not retain the format 5.00 becomes 5 1
TransferSpreadsheet still truncates the memo field 1
Export Results of Access 2000 query to text file. 2
Dates in Export Specification Inconsistent in results 1
Problems Exporting from Access 4
XML File - Date field formatting? 1

Top