Schema.INI

[Fabio Furukawa]

I'm exporting a query to a text csv file. I have a column Number double
without decimals, when I export this column Ms Access always posfix it with
".00". Once some one told me that access uses schema.ini to configure the
export. But in this case my schema.ini is not created.

I want to know if there is a way of configuring access not to put ".00" or I
always have to use "Format" function in this column ?

Regards
Fabio

 

[tina]

well if the values in that field *in the table* are ALWAYS whole numbers,
never decimals, consider changing the field size *in the table* from Double
to Long Integer. if you decide to do this, suggest you try it on a *copy of
your table* first.

other than the above, you might try changing the Decimal Places property *in
the table*, which i'm guessing is set to Auto for this field, to 0 (zero). i
believe a new query will inherit the table property settings for the fields
used in the query; for an existing table, you can change the field property
in query Design view. keep in mind that whether changed in table or query,
or both, this changes display only, not values, while the query exports
values, so it may not work.

hth

 

[Fabio Furukawa]

Tks. I changed the data type and i worked well

well if the values in that field *in the table* are ALWAYS whole numbers,
never decimals, consider changing the field size *in the table* from Double
to Long Integer. if you decide to do this, suggest you try it on a *copy of
your table* first.

other than the above, you might try changing the Decimal Places property *in
the table*, which i'm guessing is set to Auto for this field, to 0 (zero). i
believe a new query will inherit the table property settings for the fields
used in the query; for an existing table, you can change the field property
in query Design view. keep in mind that whether changed in table or query,
or both, this changes display only, not values, while the query exports
values, so it may not work.

hth

 

[tina]

you're welcome

Tks. I changed the data type and i worked well