Exporing Numbers from a query

[Chris]

I have a query that gives me the total points with zero
decimal places(the whole number)like 300, 450. The problem
is when I export the query to html I get 300.00, 450.00
with 2 decimal places. I tried making changes in the table
properties and nothing seems to work. I am opening it up
in Front Page as well. Iif I can make changes there that
would be great also.

Any Suggestions

Chris

 

[Robert]

I have been having the exact same problem except I am
transferring to a text file and it is driving me nuts...if
you get any answer, I'd love to hear it...

Robert

 

[Cheryl Fischer]

You can export this field as CInt([MyField]) or CLng([MyField]) in your
query. A quick test here showed that there were no decimal places when a
query using either of these functions was exported to HTML.

 

[Chris]

Thank You Cheryl but I am still confused on where to put
this expression. Some fields are built on expressions in
the Zoom box. Can you give a more detailed description on
how to export the field.

Thank You

Chris

-----Original Message-----
You can export this field as CInt([MyField]) or CLng ([MyField]) in your
query. A quick test here showed that there were no decimal places when a
query using either of these functions was exported to HTML.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I have a query that gives me the total points with zero
decimal places(the whole number)like 300, 450. The problem
is when I export the query to html I get 300.00, 450.00
with 2 decimal places. I tried making changes in the table
properties and nothing seems to work. I am opening it up
in Front Page as well. Iif I can make changes there that
would be great also.

Any Suggestions

Chris

.

 

[Cheryl Fischer]

Chris,

You indicate that you have a field in your query that produces values like
300.00, 400.00. You do not say what the name of that field is, so let's
presume that the field name is MyPoints. Go to the column in your query's
design view that is producing the point values with decimals and, in the
first row of that column, replace what is there with:

LngMyPoints: CLng([MyPoints])


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Thank You Cheryl but I am still confused on where to put
this expression. Some fields are built on expressions in
the Zoom box. Can you give a more detailed description on
how to export the field.

Thank You

Chris

-----Original Message-----
You can export this field as CInt([MyField]) or CLng ([MyField]) in your
query. A quick test here showed that there were no decimal places when a
query using either of these functions was exported to HTML.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I have a query that gives me the total points with zero
decimal places(the whole number)like 300, 450. The problem
is when I export the query to html I get 300.00, 450.00
with 2 decimal places. I tried making changes in the table
properties and nothing seems to work. I am opening it up
in Front Page as well. Iif I can make changes there that
would be great also.

Any Suggestions

Chris

.

 

[Chris]

Cheryl,

Thank you very Much for your help.

Sincerely,

Chris

-----Original Message-----
Chris,

You indicate that you have a field in your query that produces values like
300.00, 400.00. You do not say what the name of that field is, so let's
presume that the field name is MyPoints. Go to the column in your query's
design view that is producing the point values with decimals and, in the
first row of that column, replace what is there with:

LngMyPoints: CLng([MyPoints])


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Thank You Cheryl but I am still confused on where to put
this expression. Some fields are built on expressions in
the Zoom box. Can you give a more detailed description on
how to export the field.

Thank You

Chris

-----Original Message-----
You can export this field as CInt([MyField]) or

CLng
([MyField]) in your

query. A quick test here showed that there were no decimal places when a
query using either of these functions was exported to HTML.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


I have a query that gives me the total points with zero
decimal places(the whole number)like 300, 450. The problem
is when I export the query to html I get 300.00, 450.00
with 2 decimal places. I tried making changes in the table
properties and nothing seems to work. I am opening it up
in Front Page as well. Iif I can make changes there that
would be great also.

Any Suggestions

Chris


.

.

 

[Jeff]

Hi,

I seem to have the exact opposite problem. When I export
a field with decimals from a query to a .csv, the decimals
are truncated to two places. Since the numbers I want to
export contain more than two decimal places, I'd like to
know if there is any way to change the settings to enable
detail beyond two places.

Any help would be GREATLY appreciated. Thanks,

Jeff

 

[Jeff]

I think I found the answer to my question:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q153364

 

[Andrew]

Another way to solve the loss of decimal places when
exporting to a .csv file is to change the Regional Settings
in the windows control panel. Under regional settings or
options you can change the number of decimal places for a
number format. Apparently access gets some of its ettings
from this area of windows.