B
Bongard
I have a linked table in which I can't change the data types and the
amount field is a decimal data type. From that table I combine some
other fields from other tables with a make table query. Ultimately I
run a crosstab that gives me the message (Decimal data type doesn't
have enough precision) or something like that. I can then go manually
into my make table and change the data type to double everytime I run
it but I would like this to happen automatically. Could I change the
data type from decimal-double using an append or an update query
somehow?
Thanks for your help!
Brian
amount field is a decimal data type. From that table I combine some
other fields from other tables with a make table query. Ultimately I
run a crosstab that gives me the message (Decimal data type doesn't
have enough precision) or something like that. I can then go manually
into my make table and change the data type to double everytime I run
it but I would like this to happen automatically. Could I change the
data type from decimal-double using an append or an update query
somehow?
Thanks for your help!
Brian