Make Table Query not inheriting data types

[JamesMcS]

Hi all, hope you can help out with an annoying problem:

I've got a make table query based on a number of crosstabs, the value field of which I've CDbl'd to make sure it comes out as a number. The crosstabs seem to display the data as a number OK, but when I incorporate them all into the make table, they all come out as text. Grrr!

I've formatted the fields in the make table as numbers in the vain hope that that might make a difference, but no joy..... anybody know what I'm missing?

 

[JamesMcS]

Got around it by CDbling the make table fields too. Thanks for the pointer VBA, I thought my method was a bit rubbish, I'll look into tabledefs now.

 

[vbaInet]

This is one of those things I don't use often. A make table query will follow the datatype that is used in the field. If however, it's a calculated field (which I think yours is), then it would make it a text field. You would have to use the TableDef collection to change the properties after creation.

 

[JamesMcS]

Genius as always, cheers again

 

[vbaInet]

No problemo.