[AccessD] Data Type Mismatch

Hi Keith

No, you are turning them into strings.
Wrap them in VAL().

/gustav

>>> Kwilliamson at RTKL.com 16-01-2007 17:03:24 >>>
My [Period] field is the source for both "Month" and "Year".  The period
is formatted as a number, in the source table; consisting of YearMonth
(ie. 200610 - for October 2006.)  IF I use "left([period],4)" to
generate year, and "right([period],2)" to generate month........does
this change the data type?  Using left function on a long integer,
should still keep the result in long integer format, wouldn't it?

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com