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

Post your SQL. I bet that if you put double quotes around the "999" it will
work.
--
KARL DEWEY
Build a little - Test a little


"S Davis" wrote:

> 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
>
>