type mismatch error

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

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.
 
I would check the lookup tables foreign and primary key fields to make sure
they are the same data types.
Click to expand...

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.
 
Back
Top