Make Table Query Field Properties

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

hello,

I'm trying to run a make table query where a user will
enter in data to be put into the new table. (i.e. date,
hours, etc.) Yet, when the table is created the date and
hours fields are selected as "binary" type. When I try to
convert them to date/number, it deletes all the data. How
can I specify the field type I want created and not make
them binary? Thanks for your help.

-Sean
 
Hi,


You probably created the table with a "SELECT INTO" and the selected field
was NULL. Since Jet was unable to decide what was the datatype (you use Jet
by the way? ) it decides to use a special datatype (that is not even
available in the user interface). Rather than using just Null, try that
special construction:

SELECT iif( False, Now( ), Null ) As MyField INTO toto


That should create a table toto with MyField as a dateTime field (from an
initial observation made by John L. Viescas in a semi-private conversation
about that particular use of iif ).




Hoping it may help,
Vanderghast, Access MPV
 
Back
Top