Query to table Data type changes

[neilb]

Hi

I have created a query that puts the date and time together to form a general date format by using a format([date] & " " & [time],"general date") FORMULA. I have also set the properties to show as generaldate in the make table query.

When I run the query it creates the table but makes the date and time field a text data type. If I correct it in the table and then re run the query it makes it a text again.

Am I missing something to stop this happening

 

[Norie]

The format function returns a String ie Text.

If I correct it in the table and then re run the query it makes it a text again

What type of query?

ASFAIK the only query that could change a datatype is a Make Table query.

 

[neilb]

It is a make table query

 

[Norie]

Neil

I don't know if it would work but why not create a table with the fields the data type you want.

Then change the make table to and append query to the new table.

Also take a look at the CDate type conversion function.

eg CDate(Format([date] & " " & [time],"general date") )

 

[neilb]

Many thanks that worked great.