Keith Williamson
Kwilliamson at RTKL.com
Tue Jan 16 09:41:44 CST 2007
The report, itself, runs as well. It is only when I try running the report, from my form, with criteria. It is the criteria (I have textboxes to input Month, Year, and Entity) which the user fills in, that is creating the data mismatch. 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 artful at rogers.com Sent: Tuesday, January 16, 2007 10:10 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data Type Mismatch I assume this means you can run the query itself successfully without running the report. If that is the case, then are there any controls on the report which are calculated on the basis of the query contents? I would also try generating an autoreport based on the query, then comparing it with your original report. It's a little tedious, but you could open them side by side and compare the controls one by one. hth, Arthur ----- Original Message ---- From: Keith Williamson <Kwilliamson at rtkl.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Tuesday, January 16, 2007 9:56:09 AM Subject: [AccessD] Data Type Mismatch 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com