How to control data type of Make-table query

[klar]

Dear Access Gurus,

I have a make-table query. After the query is converted into a table, the data types of the table are all "Text". What I want is to convert them to "Numbers" type. Is there some way to do this?

Below is the query I used. Is this the cause of the problem?

Val: Format(GetValue([Info]![ID]),"#,##0.0000")

 

[spikepl]

Yes. You feed text to it, and so, not surprisingly, you get text back.

Stick formatting of data into the form or report where you display the data, not into the table.

BTW: Val is a reserved word - not a good choice for column name