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