Exporting numbers to a text file with more than 2 decimal digits

[Reg]

Hi everyone.
I have a database with 3 fields.
First 2 fields have numbers with up to 7 digits after the decimal point,
last field has 2 digits after the decimal point.
When I export the data to a text file, Access exports all the data with only
2 digits after the decimal point.

How do I get Access to export the data to the full resolution of the data
stored in the database ?

 

[tina]

export the data from a query, rather than directly from the table. in query
design view, create a calculated field for each field in the table, using
the Format() function, as

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

hth

 

[Reg]

Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the name of the
database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate column in
the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window and set the
number format. I did this but there is no "OK" or done" button for me to
press to ensure the change has been set and there's no obvious display of the
fact that I've forced the number format, although re-opening the properties
box, correctly shows the number formats I set for each field. I presume I
have done what you recommended, just via one of the very many different paths
by which it is probably achievable.

There is now a "Query1" icon displayed in the query window. I double click
on it assuming this will run the query. The data is displayed, but not it is
not formatted with a fixed number decimal places which is what I chose when I
set the number format. I choose "File-> Export" just to see what happens.
The text file contains all the data displayed with 2 decimal places.

I'm sure you're on the right track, I just have no idea how implement what
you're recommending. I can't figure out where to put the commands you're
showing me.

Thanks for your time.

Regards,

Reg.

 

[tina]

in query design view, *don't* add any fields to the grid in the bottom half
of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled "Field:".
in each case, substitute the correct name of a field in place of "FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change it to
whatever you want - as long as it is *not* the same as the name of the field
you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth

 

[Reg]

Hi Tina. I'm completely confused by your description of what I'm supposed to
do.

I just had a thought, I neglected to tell you I'm using Access 2000. Does
that make a difference to how all this works !?

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first. "Field:" is in the grid in
the bottom half of the window, so it's not possible on the one hand to enter
the correct name and not modify the grid in the bottom half of the window.

Secondly, "Field:" is completely blank in all rows. FieldName does not
appear anywhere. Was I supposed to "Add my Table" when the "Show Table"
window was displayed ?

Assuming, at this point, you're still willing to help a person with my
"ZERO! level of experience with Access" here are the names of the database,
table & fields I'm working with , so you don't have to use generic names.
The Database is called GNSW_P756DEM.
The Table is called GSNSW_P756DEM_L_L_DEM. That's pretty catchy really !
It has 3 fields Latitude, Longitude & FinalDEM.

Here's what I did.

Opened the Database.
Clicked on Queries.
Double clicked on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the Field cell for the 1st column, I choose "Latitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 1st column is checked.
In the Field cell for the 2nd column, I choose "Longitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 2nd column is checked.
In the Field cell for the 3rd column, I choose "FinalDEM".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 3rd column is checked.

The are 3 more rows, labelled "Sort", "Criteria" & "or:", they are all blank.

In the next row after "or:", which does not have a title, I enter
"Lat: Format(Latitude, "0.0000000")

When I do, I get this error.

"The expression you entered has an invalid . (dot) or (!) operator or
invalid parantheses.
You may have entered an invalid identifier or typed parathenses following
the Null constant."

I also tried Lat: Format([Latitude], "0.0000000") and got the same error.

WHAT DID I DO INCORRECTLY ?

Reg.

in query design view, *don't* add any fields to the grid in the bottom half
of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled "Field:".
in each case, substitute the correct name of a field in place of "FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change it to
whatever you want - as long as it is *not* the same as the name of the field
you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth

Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the name of the
database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate column in
the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window and set the
number format. I did this but there is no "OK" or done" button for me to
press to ensure the change has been set and there's no obvious display of the
fact that I've forced the number format, although re-opening the properties
box, correctly shows the number formats I set for each field. I presume I
have done what you recommended, just via one of the very many different paths
by which it is probably achievable.

There is now a "Query1" icon displayed in the query window. I double click
on it assuming this will run the query. The data is displayed, but not it is
not formatted with a fixed number decimal places which is what I chose when I
set the number format. I choose "File-> Export" just to see what happens.
The text file contains all the data displayed with 2 decimal places.

I'm sure you're on the right track, I just have no idea how implement what
you're recommending. I can't figure out where to put the commands you're
showing me.

Thanks for your time.

Regards,

Reg.

 

[tina]

You wrote "don't add any fields to the grid in the bottom half of the

window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first.

Reg, you left out part of what i posted. my instructions in my second post
were:

< in query design view, *don't* add any fields to the grid in the bottom
half
of the window. INSTEAD, ADD ONE OF THE EXPRESSIONS I GAVE YOU TO EACH OF
THREE BLANK COLUMNS IN THE GRID, IN THE TOP ROW WHICH IS LABELED "FIELD:". >

when you read the complete text, especially if you're looking at a query
design view, it should make sense. i previously gave you those expressions
in my first post:

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

in my second post, i went on to say:

< in each case, substitute the correct name of a field in place of
"FieldName"
in the expression.>

again, when you're looking at the correctly placed expression in a query
design view, it should be obvious. i think that's as clear as i can make it.

hth

Hi Tina. I'm completely confused by your description of what I'm supposed to
do.

I just had a thought, I neglected to tell you I'm using Access 2000. Does
that make a difference to how all this works !?

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first. "Field:" is in the grid in
the bottom half of the window, so it's not possible on the one hand to enter
the correct name and not modify the grid in the bottom half of the window.

Secondly, "Field:" is completely blank in all rows. FieldName does not
appear anywhere. Was I supposed to "Add my Table" when the "Show Table"
window was displayed ?

Assuming, at this point, you're still willing to help a person with my
"ZERO! level of experience with Access" here are the names of the database,
table & fields I'm working with , so you don't have to use generic names.
The Database is called GNSW_P756DEM.
The Table is called GSNSW_P756DEM_L_L_DEM. That's pretty catchy really !
It has 3 fields Latitude, Longitude & FinalDEM.

Here's what I did.

Opened the Database.
Clicked on Queries.
Double clicked on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the Field cell for the 1st column, I choose "Latitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 1st column is checked.
In the Field cell for the 2nd column, I choose "Longitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 2nd column is checked.
In the Field cell for the 3rd column, I choose "FinalDEM".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 3rd column is checked.

The are 3 more rows, labelled "Sort", "Criteria" & "or:", they are all blank.

In the next row after "or:", which does not have a title, I enter
"Lat: Format(Latitude, "0.0000000")

When I do, I get this error.

"The expression you entered has an invalid . (dot) or (!) operator or
invalid parantheses.
You may have entered an invalid identifier or typed parathenses following
the Null constant."

I also tried Lat: Format([Latitude], "0.0000000") and got the same error.

WHAT DID I DO INCORRECTLY ?

Reg.

in query design view, *don't* add any fields to the grid in the bottom half
of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled "Field:".
in each case, substitute the correct name of a field in place of "FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change it to
whatever you want - as long as it is *not* the same as the name of the field
you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth

Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the name of the
database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate column in
the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window and

set
the

number format. I did this but there is no "OK" or done" button for me to
press to ensure the change has been set and there's no obvious display

of
the

fact that I've forced the number format, although re-opening the properties
box, correctly shows the number formats I set for each field. I presume I
have done what you recommended, just via one of the very many

different
paths

by which it is probably achievable.

There is now a "Query1" icon displayed in the query window. I double click
on it assuming this will run the query. The data is displayed, but

not it
is

not formatted with a fixed number decimal places which is what I chose when I
set the number format. I choose "File-> Export" just to see what happens.
The text file contains all the data displayed with 2 decimal places.

I'm sure you're on the right track, I just have no idea how implement what
you're recommending. I can't figure out where to put the commands you're
showing me.

Thanks for your time.

Regards,

Reg.

:

export the data from a query, rather than directly from the table.

in
query

design view, create a calculated field for each field in the table, using
the Format() function, as

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

hth


Hi everyone.
I have a database with 3 fields.
First 2 fields have numbers with up to 7 digits after the decimal point,
last field has 2 digits after the decimal point.
When I export the data to a text file, Access exports all the data with
only
2 digits after the decimal point.

How do I get Access to export the data to the full resolution of

the
data

stored in the database ?

 

[Reg]

Hi Tina.

It's great to know that people of your competency are willing to persist
with people of my competency..... THANK YOU !

I really appreciate your persistence in spite of my critique....... THANK
YOU !

Here's what I did and it WORKED with one minor problem which was fixable
with WORD !...... THANK YOU !

I still find your description of the process confusing.

Here's what I did.

The Database I'm using is called GSNSW_P756DEM.
The Table in this database is called GSNSW_P756DEM_L_L_DEM.
It has 3 fields Latitude, Longitude & FinalDEM.

Open the Database.
Click on Queries.
Double click on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the "Field:" cell for the 1st column, I enter
LAT: Format(Latitude, "0.0000000")
and the "Show:" cell for the 1st column is checked automatically.
In the "Field:" cell for the 2nd column, I enter
LONG: Format(Longitude, "0.0000000")
and the "Show" cell for the 2nd column is checked automatically.
In the Field cell for the 3rd column,
I enter DEM: Format(FinalDEM, "0.00")
and the "Show:" cell for the 3rd column is checked automatically.

I close the Query 1 window and get asked to save it.
I save it named "Export in full resolution".
Now I have a Query with that name in the Database window.

I double click on that and the data is displayed as I want it.

I export the data and leave "Save all formatted" unchecked.

The data is correctly saved ! Bow in Tina's direction !
When I look at the data, each value has a double quote (") before and after
it.
I open Word and use Replace to remove all the double quotes and the data is
now in a text file exactly as I want it.

THANK YOU THANK YOU THANK YOU !

Regards,

Reg.

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first.

Reg, you left out part of what i posted. my instructions in my second post
were:

< in query design view, *don't* add any fields to the grid in the bottom
half
of the window. INSTEAD, ADD ONE OF THE EXPRESSIONS I GAVE YOU TO EACH OF
THREE BLANK COLUMNS IN THE GRID, IN THE TOP ROW WHICH IS LABELED "FIELD:". >

when you read the complete text, especially if you're looking at a query
design view, it should make sense. i previously gave you those expressions
in my first post:

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

in my second post, i went on to say:

< in each case, substitute the correct name of a field in place of
"FieldName"
in the expression.>

again, when you're looking at the correctly placed expression in a query
design view, it should be obvious. i think that's as clear as i can make it.

hth

Hi Tina. I'm completely confused by your description of what I'm supposed to
do.

I just had a thought, I neglected to tell you I'm using Access 2000. Does
that make a difference to how all this works !?

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first. "Field:" is in the grid in
the bottom half of the window, so it's not possible on the one hand to enter
the correct name and not modify the grid in the bottom half of the window.

Secondly, "Field:" is completely blank in all rows. FieldName does not
appear anywhere. Was I supposed to "Add my Table" when the "Show Table"
window was displayed ?

Assuming, at this point, you're still willing to help a person with my
"ZERO! level of experience with Access" here are the names of the database,
table & fields I'm working with , so you don't have to use generic names.
The Database is called GNSW_P756DEM.
The Table is called GSNSW_P756DEM_L_L_DEM. That's pretty catchy really !
It has 3 fields Latitude, Longitude & FinalDEM.

Here's what I did.

Opened the Database.
Clicked on Queries.
Double clicked on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the Field cell for the 1st column, I choose "Latitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 1st column is checked.
In the Field cell for the 2nd column, I choose "Longitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 2nd column is checked.
In the Field cell for the 3rd column, I choose "FinalDEM".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 3rd column is checked.

The are 3 more rows, labelled "Sort", "Criteria" & "or:", they are all blank.

In the next row after "or:", which does not have a title, I enter
"Lat: Format(Latitude, "0.0000000")

When I do, I get this error.

"The expression you entered has an invalid . (dot) or (!) operator or
invalid parantheses.
You may have entered an invalid identifier or typed parathenses following
the Null constant."

I also tried Lat: Format([Latitude], "0.0000000") and got the same error.

WHAT DID I DO INCORRECTLY ?

Reg.

in query design view, *don't* add any fields to the grid in the bottom half
of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled "Field:".
in each case, substitute the correct name of a field in place of "FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change it to
whatever you want - as long as it is *not* the same as the name of the field
you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth


Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the name of the
database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate column in
the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window and set
the
number format. I did this but there is no "OK" or done" button for me to
press to ensure the change has been set and there's no obvious display of
the
fact that I've forced the number format, although re-opening the
properties
box, correctly shows the number formats I set for each field. I presume I
have done what you recommended, just via one of the very many different
paths
by which it is probably achievable.

There is now a "Query1" icon displayed in the query window. I double
click
on it assuming this will run the query. The data is displayed, but not it
is
not formatted with a fixed number decimal places which is what I chose
when I
set the number format. I choose "File-> Export" just to see what happens.
The text file contains all the data displayed with 2 decimal places.

I'm sure you're on the right track, I just have no idea how implement what
you're recommending. I can't figure out where to put the commands you're
showing me.

Thanks for your time.

Regards,

Reg.

:

export the data from a query, rather than directly from the table. in
query
design view, create a calculated field for each field in the table,
using
the Format() function, as

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

hth


Hi everyone.
I have a database with 3 fields.
First 2 fields have numbers with up to 7 digits after the decimal
point,
last field has 2 digits after the decimal point.
When I export the data to a text file, Access exports all the data
with
only
2 digits after the decimal point.

How do I get Access to export the data to the full resolution of the
data
stored in the database ?

 

[tina]

you're welcome. you followed the query directions correctly. to prevent the
double quotes from being added to the text file on export, and assuming that
you're exporting from File|Export on the menu bar:

when the Export Text Wizard opens, click the Next button. choose your
delimiter (Comma, or whatever), and click the droplist arrow in the Text
Qualifier field. choose {none} from the list. continue through the rest of
the wizard as usual. the file should export without the double quotes around
each value.

hth

Hi Tina.

It's great to know that people of your competency are willing to persist
with people of my competency..... THANK YOU !

I really appreciate your persistence in spite of my critique....... THANK
YOU !

Here's what I did and it WORKED with one minor problem which was fixable
with WORD !...... THANK YOU !

I still find your description of the process confusing.

Here's what I did.

The Database I'm using is called GSNSW_P756DEM.
The Table in this database is called GSNSW_P756DEM_L_L_DEM.
It has 3 fields Latitude, Longitude & FinalDEM.

Open the Database.
Click on Queries.
Double click on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the "Field:" cell for the 1st column, I enter
LAT: Format(Latitude, "0.0000000")
and the "Show:" cell for the 1st column is checked automatically.
In the "Field:" cell for the 2nd column, I enter
LONG: Format(Longitude, "0.0000000")
and the "Show" cell for the 2nd column is checked automatically.
In the Field cell for the 3rd column,
I enter DEM: Format(FinalDEM, "0.00")
and the "Show:" cell for the 3rd column is checked automatically.

I close the Query 1 window and get asked to save it.
I save it named "Export in full resolution".
Now I have a Query with that name in the Database window.

I double click on that and the data is displayed as I want it.

I export the data and leave "Save all formatted" unchecked.

The data is correctly saved ! Bow in Tina's direction !
When I look at the data, each value has a double quote (") before and after
it.
I open Word and use Replace to remove all the double quotes and the data is
now in a text file exactly as I want it.

THANK YOU THANK YOU THANK YOU !

Regards,

Reg.

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first.

Reg, you left out part of what i posted. my instructions in my second post
were:

< in query design view, *don't* add any fields to the grid in the bottom
half
of the window. INSTEAD, ADD ONE OF THE EXPRESSIONS I GAVE YOU TO EACH OF
THREE BLANK COLUMNS IN THE GRID, IN THE TOP ROW WHICH IS LABELED "FIELD:". >

when you read the complete text, especially if you're looking at a query
design view, it should make sense. i previously gave you those expressions
in my first post:

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

in my second post, i went on to say:

< in each case, substitute the correct name of a field in place of
"FieldName"
in the expression.>

again, when you're looking at the correctly placed expression in a query
design view, it should be obvious. i think that's as clear as i can make it.

hth

Hi Tina. I'm completely confused by your description of what I'm

supposed
to

do.

I just had a thought, I neglected to tell you I'm using Access 2000. Does
that make a difference to how all this works !?

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first. "Field:" is in the

grid
in

the bottom half of the window, so it's not possible on the one hand to enter
the correct name and not modify the grid in the bottom half of the window.

Secondly, "Field:" is completely blank in all rows. FieldName does not
appear anywhere. Was I supposed to "Add my Table" when the "Show Table"
window was displayed ?

Assuming, at this point, you're still willing to help a person with my
"ZERO! level of experience with Access" here are the names of the database,
table & fields I'm working with , so you don't have to use generic names.
The Database is called GNSW_P756DEM.
The Table is called GSNSW_P756DEM_L_L_DEM. That's pretty catchy really !
It has 3 fields Latitude, Longitude & FinalDEM.

Here's what I did.

Opened the Database.
Clicked on Queries.
Double clicked on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4

lines
in

it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the Field cell for the 1st column, I choose "Latitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 1st column is checked.
In the Field cell for the 2nd column, I choose "Longitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 2nd column is checked.
In the Field cell for the 3rd column, I choose "FinalDEM".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below Field)
and the "Show" cell for the 3rd column is checked.

The are 3 more rows, labelled "Sort", "Criteria" & "or:", they are all blank.

In the next row after "or:", which does not have a title, I enter
"Lat: Format(Latitude, "0.0000000")

When I do, I get this error.

"The expression you entered has an invalid . (dot) or (!) operator or
invalid parantheses.
You may have entered an invalid identifier or typed parathenses following
the Null constant."

I also tried Lat: Format([Latitude], "0.0000000") and got the same error.

WHAT DID I DO INCORRECTLY ?

Reg.



:

in query design view, *don't* add any fields to the grid in the

bottom
half

of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled "Field:".
in each case, substitute the correct name of a field in place of "FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change

it
to

whatever you want - as long as it is *not* the same as the name of

the
field

you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth


Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the

name of
the

database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate

column
in

the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window

and
set

the
number format. I did this but there is no "OK" or done" button

for me
to

press to ensure the change has been set and there's no obvious

display
of

the
fact that I've forced the number format, although re-opening the
properties
box, correctly shows the number formats I set for each field. I presume I
have done what you recommended, just via one of the very many different
paths
by which it is probably achievable.

There is now a "Query1" icon displayed in the query window. I double
click
on it assuming this will run the query. The data is displayed,

but
not it

is
not formatted with a fixed number decimal places which is what I chose
when I
set the number format. I choose "File-> Export" just to see what happens.
The text file contains all the data displayed with 2 decimal places.

I'm sure you're on the right track, I just have no idea how

implement
what

you're recommending. I can't figure out where to put the commands you're
showing me.

Thanks for your time.

Regards,

Reg.

:

export the data from a query, rather than directly from the

table.
in

query
design view, create a calculated field for each field in the table,
using
the Format() function, as

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

hth


Hi everyone.
I have a database with 3 fields.
First 2 fields have numbers with up to 7 digits after the decimal
point,
last field has 2 digits after the decimal point.
When I export the data to a text file, Access exports all the data
with
only
2 digits after the decimal point.

How do I get Access to export the data to the full resolution

of
the

data
stored in the database ?

 

[Reg]

Thanks Tina.

Reg.

you're welcome. you followed the query directions correctly. to prevent the
double quotes from being added to the text file on export, and assuming that
you're exporting from File|Export on the menu bar:

when the Export Text Wizard opens, click the Next button. choose your
delimiter (Comma, or whatever), and click the droplist arrow in the Text
Qualifier field. choose {none} from the list. continue through the rest of
the wizard as usual. the file should export without the double quotes around
each value.

hth

Hi Tina.

It's great to know that people of your competency are willing to persist
with people of my competency..... THANK YOU !

I really appreciate your persistence in spite of my critique....... THANK
YOU !

Here's what I did and it WORKED with one minor problem which was fixable
with WORD !...... THANK YOU !

I still find your description of the process confusing.

Here's what I did.

The Database I'm using is called GSNSW_P756DEM.
The Table in this database is called GSNSW_P756DEM_L_L_DEM.
It has 3 fields Latitude, Longitude & FinalDEM.

Open the Database.
Click on Queries.
Double click on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the following.
In the "Field:" cell for the 1st column, I enter
LAT: Format(Latitude, "0.0000000")
and the "Show:" cell for the 1st column is checked automatically.
In the "Field:" cell for the 2nd column, I enter
LONG: Format(Longitude, "0.0000000")
and the "Show" cell for the 2nd column is checked automatically.
In the Field cell for the 3rd column,
I enter DEM: Format(FinalDEM, "0.00")
and the "Show:" cell for the 3rd column is checked automatically.

I close the Query 1 window and get asked to save it.
I save it named "Export in full resolution".
Now I have a Query with that name in the Database window.

I double click on that and the data is displayed as I want it.

I export the data and leave "Save all formatted" unchecked.

The data is correctly saved ! Bow in Tina's direction !
When I look at the data, each value has a double quote (") before and after
it.
I open Word and use Replace to remove all the double quotes and the data is
now in a text file exactly as I want it.

THANK YOU THANK YOU THANK YOU !

Regards,

Reg.

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first.

Reg, you left out part of what i posted. my instructions in my second post
were:

< in query design view, *don't* add any fields to the grid in the bottom
half
of the window. INSTEAD, ADD ONE OF THE EXPRESSIONS I GAVE YOU TO EACH OF
THREE BLANK COLUMNS IN THE GRID, IN THE TOP ROW WHICH IS LABELED "FIELD:". >

when you read the complete text, especially if you're looking at a query
design view, it should make sense. i previously gave you those expressions
in my first post:

SevenDigitFieldA: Format(FieldName, "0.0000000")

SevenDigitFieldB: Format(FieldName, "0.0000000")

TwoDigitField: Format(FieldName, "0.00")

in my second post, i went on to say:

< in each case, substitute the correct name of a field in place of
"FieldName"
in the expression.>

again, when you're looking at the correctly placed expression in a query
design view, it should be obvious. i think that's as clear as i can make it.

hth


Hi Tina. I'm completely confused by your description of what I'm supposed
to
do.

I just had a thought, I neglected to tell you I'm using Access 2000. Does
that make a difference to how all this works !?

You wrote "don't add any fields to the grid in the bottom half of the
window", then wrote, "in the top row, which is labelled "Field:", in each
case substitute the correct name of a field in place of "FieldName"". The
second statement seems to contradict the first. "Field:" is in the grid
in
the bottom half of the window, so it's not possible on the one hand to
enter
the correct name and not modify the grid in the bottom half of the window.

Secondly, "Field:" is completely blank in all rows. FieldName does not
appear anywhere. Was I supposed to "Add my Table" when the "Show Table"
window was displayed ?

Assuming, at this point, you're still willing to help a person with my
"ZERO! level of experience with Access" here are the names of the
database,
table & fields I'm working with , so you don't have to use generic names.
The Database is called GNSW_P756DEM.
The Table is called GSNSW_P756DEM_L_L_DEM. That's pretty catchy really !
It has 3 fields Latitude, Longitude & FinalDEM.

Here's what I did.

Opened the Database.
Clicked on Queries.
Double clicked on "Create Query in Design View"
The "Show Table" window is opened.
The "Query1 : Select Query" window is opened

The "Show Table" window has 1 table in it, "GSNSW_P756DEM_L_L_DEM"
I select that table and click "Add".

A small window now appears in the top half of the "Query1 : Select Query"
window
The window has the title of the Table (GSNSW_P756DEM_L_L_DEM) and 4 lines
in
it.
*
FinalDEM
Latitude
Longitude

I click "Close" in the "Show Table" window

In the bottom half of the "Query1 : Select Query" window, I do the
following.
In the Field cell for the 1st column, I choose "Latitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below
Field)
and the "Show" cell for the 1st column is checked.
In the Field cell for the 2nd column, I choose "Longitude".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below
Field)
and the "Show" cell for the 2nd column is checked.
In the Field cell for the 3rd column, I choose "FinalDEM".
"GSNSW_P756DEM_L_L_DEM" appears in the Table cell. (immediately below
Field)
and the "Show" cell for the 3rd column is checked.

The are 3 more rows, labelled "Sort", "Criteria" & "or:", they are all
blank.

In the next row after "or:", which does not have a title, I enter
"Lat: Format(Latitude, "0.0000000")

When I do, I get this error.

"The expression you entered has an invalid . (dot) or (!) operator or
invalid parantheses.
You may have entered an invalid identifier or typed parathenses following
the Null constant."

I also tried Lat: Format([Latitude], "0.0000000") and got the same error.

WHAT DID I DO INCORRECTLY ?

Reg.



:

in query design view, *don't* add any fields to the grid in the bottom
half
of the window. instead, add one of the expressions i gave you to each of
three blank columns in the grid, in the top row which is labeled
"Field:".
in each case, substitute the correct name of a field in place of
"FieldName"
in the expression. note that the text *before* the colon, in each
expression, is an "alias" or name for that column, so you can change it
to
whatever you want - as long as it is *not* the same as the name of the
field
you're using in the expression. example

FirstNumber: Format([FirstNumber], "0.0000000")

will not work, but

FirstNum: Format([FirstNumber], "0.0000000")

will work fine.

hth


Hi Tina.

Thanks for your reply.

I open "Query in Design View"
Access displays a "Show Table" dialogue box which displays the name of
the
database keeping the data. I click Add and close the window.

Now there is a "Query1, Select Query" window with a smaller window
displaying the fields from the database I want the data from.
I add each of the 3 three fields from my database to a separate column
in
the bottom half of the "Select Query" window.
There is an option to sort the data, I don't want to do that.
I check the "Show" checkbox, assuming this is required to get the data
displayed.
Now there are are lots of places to enter "Criteria".
Is this where I should enter the command you're recommending ?
Help says I can "right click" on any column in the query window and
set
the
number format. I did this but there is no "OK" or done" button for me
to
press to ensure the change has been set and there's no obvious display
of
the