[AccessD] Data Type Mismatch

Keith,
You could make a separate "make table" query based on the union query.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson

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.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos

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.