S
S Davis
Hello,
I have an update query with the simple criteria of 'Update Table Month
to 999 if QueryMonth is less than TableMonth'. This is part of a
rolling process to be executed by Macro. The Table containing
TableMonth is created bya maketable query, and TableMonth defaults to
text (even though it is only a number between 1 - 16). QueryMonth, the
month in my comparison query, is a value, and this causes the Data
Type MisMatch and prevents me from updating TableMonth to 999 as the
data types are different.
Is there any way I can force my query to 'create' QueryMonth as a text
value? If not, I saw in my Macro options that there is a toggle for
RunSQL - is there a simple piece of SQl I can use to look at my Table
containing TableMonth and change its properties from Text to Number?
Thanks for any help
I have an update query with the simple criteria of 'Update Table Month
to 999 if QueryMonth is less than TableMonth'. This is part of a
rolling process to be executed by Macro. The Table containing
TableMonth is created bya maketable query, and TableMonth defaults to
text (even though it is only a number between 1 - 16). QueryMonth, the
month in my comparison query, is a value, and this causes the Data
Type MisMatch and prevents me from updating TableMonth to 999 as the
data types are different.
Is there any way I can force my query to 'create' QueryMonth as a text
value? If not, I saw in my Macro options that there is a toggle for
RunSQL - is there a simple piece of SQl I can use to look at my Table
containing TableMonth and change its properties from Text to Number?
Thanks for any help