type mismatch error

I have a WorkOrder form with several dozen fields. Some of the fields are
indexes into lookup tables. When I use the Report Wizard to create a report
with just a few of the fields, everything is fine, but when I try and create
a report with all the fields, it generates a type mismatch error. Any ideas
on how to find the source of the type mismatch? Is this too complicated for
the Query Builder?

Best,
Christopher

I would check the lookup tables foreign and primary key fields to make sure
they are the same data types.

--
Duane Hookom
MS Access MVP
--

"Christopher Glaeser" wrote in message
...
I have a WorkOrder form with several dozen fields. Some of the fields are
indexes into lookup tables. When I use the Report Wizard to create a
report with just a few of the fields, everything is fine, but when I try
and create a report with all the fields, it generates a type mismatch
error. Any ideas on how to find the source of the type mismatch? Is this
too complicated for the Query Builder?

Best,
Christopher

I would check the lookup tables foreign and primary key fields to make sure
they are the same data types.

OK, I'll review all the keys for type agreement.

If Access can report a type mismatch error, can it also report the names of
the fields with the type mismatch?

Best,
Christopher

I located the error. Why didn't the Relationship Builder generate an error
message when I origianlly created the relation?

Best,
Christopher

I don't know why Access didn't point out your error earlier. Access often
attempts to make data type conversions for you.

--
Duane Hookom
MS Access MVP
--

"Christopher Glaeser" wrote in message
...
I located the error. Why didn't the Relationship Builder generate an error
message when I origianlly created the relation?

Best,
Christopher