Finding Error

[Smurfit-Stone]

Hello Board,

I have an Access dbase that is not working. I'm getting an error message "Type Mismatch in Expression" I understand that I am attempting to join two types of data that don't match, but I can't find it. How do I get Access to indicate which expression/s are not matching? I'm stuck and dont' know where to go from here....thanks in advance

 

[Joe4]

When are you getting that error message (what action are you performing when you are getting it)?

 

[Smurfit-Stone]

I'm trying to run a query. My company has 150 location in the US, our corporate HQ is in chicago. Someone changed a file I download into Access from our mainframe. (Open Receivables). Now the dbase doesn't work properly. I figured out that the column headings had changed in the corporate form so I change my query to match...the query runs, But reports associated with the query won't run and are giving me this error "Type Mismatch in Expression"

 

[Joe4]

It sounds like the Format of certain fields has changed, i.e. what once was formatted as Text if now formatted as Numeric or something like that.

Try opening up the Data Sources for your query, one-by-one until you get that error. Then focus in on that table and see if you can determine which field may have changed.

If you do not get that error opening the data sources individually, but do when you get the query, then check to see that the fields involved in your join are the same format, or if the problem is with any expressions you may have in the query (i.e. trying to perform an arithmeric calculation on a Text field).