mismatch JOIN Expression Problem

E

esparzaone

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?
 
S

Steve Schapel

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