How to set up default number format in a make-table query?

[Guest]

I have a table containing numbers and I have configured it in standard
format, i.e. 12345.68 shown as 12,345.68. However, when I transmit the data
into a new table by make-table query, the format is gone. I did try to
configure the format at the properties of the field in the query and it is
successful in query view. But when I change it back to make table query, it
is gone again. Anyone can help? Thanks.

Frances

 

[Duane Hookom]

Does it make a difference? I never set these properties in a table but
choose to set properties in text boxes on forms and reports.

I really doubt that a make table query can be modified in any way to carry
over formatting.

 

[John Vinson]

I have a table containing numbers and I have configured it in standard
format, i.e. 12345.68 shown as 12,345.68. However, when I transmit the data
into a new table by make-table query, the format is gone. I did try to
configure the format at the properties of the field in the query and it is
successful in query view. But when I change it back to make table query, it
is gone again. Anyone can help? Thanks.

Frances

In my experience, MakeTable queries are VERY rarely necessary. Could
you explain why you're creating a new table as a routine operation?
Could you instead use a Query based on your main table? Queries can be
used as the recordsource for a form, for a report, for export - pretty
much anything you'ld do with a new table.

John W. Vinson[MVP]

 

[Guest]

Dear John,

As I need to update the source table regularly and change the Julian date of
the source table into normal date for ease the data tracing, then I use the
make-table query to replace the original julian date field. Thanks.

Frances

 

[John Vinson]

Dear John,

As I need to update the source table regularly and change the Julian date of
the source table into normal date for ease the data tracing, then I use the
make-table query to replace the original julian date field. Thanks.

That's going all the way around Robin's barn!

Either add a date/time field to the source table and use an Update
query to fill it with the converted Julian date, or use an Append or
Update query to update your local table's date field. I cannot see how
deleting and recreating a table is necessary for this action!

John W. Vinson[MVP]