Make Table Query Saving Formatting into Table

[dnelson24]

How do I get a Table created with a Make Table Query to retain the formatting from the query. I have formatted every field in the query so that when I do a Datasheet view of the query it looks great. As soon as I run the query and make the table the formatting looks raw.

Thanks in advance!

 

[Ogart]

What you're formatting in the query is the mask. E.g. "even though this is a Double number, make it look like currency with two decimal places."

I *Think* you need to run a fuction over it to convert it. To convert to a double, I think its Cdbl([the table you're pulling]). I *think* this stuff works on a query.

If I'm wrong let me know. -->Just because you can, doesn't mean you should.

 

[JeroenNL]

Alternatively, you can convert the make-table query to an append query. First, create the table you want to store your data into and give it any format you like. Whenever you want to update this table, use a delete query to delete all data in that table, then use the append query to update the table again. This will make sure that any formatting of the table isn't lost. You only have to set the format of the table field once. However, if you have an autonumber field, this might not be what you want. Just a suggestion though.


Bye,
Jeroen

A 3d level editor in Delphi

http://www.gamefortress.com/~delgine