Make table qry - number format as Double

[D]

Hi:

Can you please tell me what would be the way to format a number on the
result table (after make table qry) as double; the resulting field is 'long
integer'; and if I want to update it with a large number is not working; I
have to change it to Double in the design mode and do the update after that.

Thanks,

Dan

 

[Jerry Whittle]

To be pedantic about it, you do not "format" is as a double. Format is how
things are displayed. What you want to do is to change the data type of how
the number is stored. Try a query like below with the correct table and field
names.

Alter table ADJ Alter column TestNumber DOUBLE ;

 

[D]

Thanks a lot Jerry; it worked!

Dan

To be pedantic about it, you do not "format" is as a double. Format is how
things are displayed. What you want to do is to change the data type of how
the number is stored. Try a query like below with the correct table and field
names.

Alter table ADJ Alter column TestNumber DOUBLE ;