SELECT qry - type mismatch

  • Thread starter Thread starter Mimi
  • Start date Start date
M

Mimi

Hi-
I imported an A97 db into A2K and so far things have been
working well. Today I noticed that several SELECT
queries are having problems:
I try to open the SELECT query in Design view and I
get "Type mismatch in expression" error and then it
automatically opens it in SQL view.
I try to run it from SQL view and I get the same error
message.

Does anyone have an idea why it might be happening and
what steps I could take to fix it?
Any help would be greatly appreciated.
Thanks,
Mimi
..
 
Mimi,
If you can copy your sql and paste it into a message
here, you'll probably get more help.
 
Back
Top