Creating Table with query, wrong data type

  • Thread starter Thread starter Nacho
  • Start date Start date
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: (e-mail address removed)
msn: (e-mail address removed)
Tel. (54-11) 4792-8757



..
 
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.
 
And how's tha what access thinks? based on the data type?

--

Nacho Chiviló
_______________________________________________________________________
mail: (e-mail address removed)
msn: (e-mail address removed)
Tel. (54-11) 4792-8757



..
 
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: (e-mail address removed)
msn: (e-mail address removed)
Tel. (54-11) 4792-8757



..
 
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.
 
And how's that? can i do it in access 2002? any tutorial at hand?

thks very much, you are much help

--

Nacho Chiviló
_______________________________________________________________________
mail: (e-mail address removed)
msn: (e-mail address removed)
Tel. (54-11) 4792-8757



..
 
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>
 
Back
Top