Keith Williamson
Kwilliamson at RTKL.com
Tue Jan 16 10:44:09 CST 2007
Once again proving I am NOT the smartest person in the world. :)) Come to think of it....I seem to prove that quite regularly. LOL Thanks for the help guys!! Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland 21231-3305 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Tuesday, January 16, 2007 11:27 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data Type Mismatch No. Anything you do to edit a numeric will give you a text type field back I think. GK On 1/16/07, Keith Williamson <Kwilliamson at rtkl.com> wrote: > 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 > > RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland > 21231-3305 > > 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith > Williamson > Sent: Tuesday, January 16, 2007 10:44 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Data Type Mismatch > > Ack! It is a Union Query that is the source for the report. I can't > change that, as I can't bring that up in Design view...only SQL view. > > Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com > > RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland > 21231-3305 > > 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos > Sent: Tuesday, January 16, 2007 10:14 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Data Type Mismatch > > Temporarily create a "Make Table Query" with the other query as input. > Create a temporary table and then run the query, open the result table > in design mode and you will see the data types. > > GK > > On 1/16/07, Keith Williamson <Kwilliamson at rtkl.com> wrote: > > Is there an easy way to determine exactly what data type is being > > returned by a query? I have a report I am trying to run, with a > > "Docmd.openreport".....but I keep getting a data mismatch error. For > > the life of me, I can't figure out why......and I've tried playing > with > > the Where statement, to get it to give me the right data...to no > avail. > > I figure, if I can definitively determine the data type, for my three > > criterias....I can format the Where statement properly.....and also > > figure out why the query is changing the data type. Grrrrr!! > > > > > > > > Thanks, > > > > > > > > Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com > > > > RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland > > 21231-3305 > > > > 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com > > <http://www.rtkl.com/> > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > Gary Kjos > garykjos at gmail.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com