Creating Table with query, wrong data type

N

Nacho

I'm creating a table with a query, but then when i use the table, i find
that the data type of one of the cells is created wrong. Is there a way to
create the table with the query with a specific data type?

Thks from Argentina

--

Nacho Chiviló
_______________________________________________________________________
mail: [email protected]
msn: [email protected]
Tel. (54-11) 4792-8757



..
 
J

Jeff Boyce

If you are describing a Make Table query, you get what Access thinks you
need.

Another approach is to use the Make Table query once, modify the table
definition of that made table to the data type you want, and thereafter, use
an Append query.
 
N

Nacho

But then i would have to make 2 queries, one for emptying the table and
another for append

any other way? can you tell access the data type that you want a cell to
have?

thks
--

Nacho Chiviló
_______________________________________________________________________
mail: [email protected]
msn: [email protected]
Tel. (54-11) 4792-8757



..
 
J

Jeff Boyce

A Make Table query doesn't, as far as I know, allow you to specify
field/data types. Yes, you would need to use two queries to re-load a table
that had fields defined your way - one delete query to clear the table and
one append query.

Another alternative would be for you to use a CREATE TABLE SQL statement.
 
J

Jeff Boyce

Nacho

Sorry, a bit out of my experience. Try searching Google.com for "CREATE
TABLE" under the MS Access group.

Good luck!

Jeff Boyce
<Access MVP>
 
Top