Export Limitation

  • Thread starter Thread starter JuLee
  • Start date Start date
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;
 
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,
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]
 
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...
 
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...
 
Back
Top