I have a table that is made from a query. It gives an ID# and Hours worked. When the table is made, the numeric datatype for Hours worked is double, decimal = auto.
Well. I have other queries that run off this table and they don't seem to work correctly unless the I change the datatype to INT and the decimal places to 0. All these queries are run consecutively in a macro. So to get the correct final results I need to code in a step to change the field to Int and decimal to 0.
But coding sure isn't a strength of mine; so could someone please tell me how to code the changes.
Thank you very much.
Lipin
Well. I have other queries that run off this table and they don't seem to work correctly unless the I change the datatype to INT and the decimal places to 0. All these queries are run consecutively in a macro. So to get the correct final results I need to code in a step to change the field to Int and decimal to 0.
But coding sure isn't a strength of mine; so could someone please tell me how to code the changes.
Thank you very much.
Lipin