mismatch JOIN Expression Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a mismatch in JOIN expressions sign pop up when I try to use my
preview button for my purchase order and any reports. Any suggestions? Is
there something I can have access do to run say an error report?
 
Esparzaone,

As far as I know, there is no built-in process to identify the exact
location of the error. My suggestion is to look at the design of the
query that the purchase order is based on, or the query behind any other
report affected. The first thing to look at is the data type of the
fields on either side of any Joins in the query, and make sure they are
of the same data type. If you can't find it, post back here with the
SQL view of the query, and someone may be able to ask some pertinent
questions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number to Number "Data Type Mismatch in Expression" in Join 1
Converted from LINUX time ok, but having issues with the between date. 4
Function containing the wrong number of arguments 5
Data type mismatch in criteria expression 7
Joining Access table to SQL table with "Float" datatype 2
Query Problem - Access 2003 1
type mismatch 1
SQL Type Mismatch 1

Back
Top