On Fri, 21 May 2010 13:35:01 -0700, S.E.
wrote:

I get a "type mismatch in expression" when saving a query. Why do I get this
and how do I correct this? My suspicion is my customerID and barcode fields
are not both autonumbers or the same type to relate but under the
relationships they join up. Please help.

My guess is that you're another victim of the misleading "Lookup Wizard" field
type. A barcode would normally be a Text field, and I'm guessing that the
CustomerID is an Autonumber (a long integer).

Posting the SQL of the query and your fields' datatypes would help.
--

John W. Vinson [MVP]