Type mismatch error in query, please help

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

Guest

I have created a query in my database that links courses to reports (it’s a
report card database)

I’m using Access 2003 but the file format is on access 2000 because that
person to who to database is intended uses access XP.

Sometimes when I open the database, its gives me a mismatch error. When I
looked closely, the join in the query changes.
I fixed it, and everything worked ok. Next time when I opened the database,
the same problem happened….
Why does the join changes?


Please help
 
Let's look at this one step at a time. Take a look at the data type of the
joining fields, are they the same?
 
I have ckeched, same datatype = Number long int against number long int. It
works fine with access 2003 only have problem with access 2002 and 2000
 
Does the message pop up when you open the database or when you run the query?
How does the query get called? from a form, a report?
 

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

Syntax error (missing operator) in query expression ‘tblDUES.’. 5
'Type Mismatch' Error- PLEASE HELP 13
Type Mismatch in Expression 1
Two different queries return same results 4
Query for Forecasting Fuel Usage 1
Hours for month as value in query 7
DSum in Query 3
Query for Multiple Lookups 2

Back
Top