Microsoft Access can't represent the join expression ..... in Desi

[Guest]

Dear all,

I have got a problem in my query.

I have a make table query and its columns. And another query wich uses this
table and other tables to make calculations.

when i run the first make table query and then open the second query in
design view, i got the error "Microsoft Access can't represent the join
expression ..... in Design view"

When i look, one of columns' of made table join has been deleted and then, i
rejoin it and the problem is being solved.

But again, if i run the first make table query again, i got the same error
and need to join again.

What i can not understand why it deletes the joint? And why, after running
the first query? and why it works, when i join again

Thank you for information,

Regards,

 

[Guest]

You can write a join in SQL that Access can not display graphically so you
will get such a message. If you join a field in one table to the
Left([Table2].[SomeTextField],3) it can not display it.

Also, sometimes it will try to fix what it thinks is your errors by
rewriting the SQL when you go to design view.

You might post your SQL so others can examine and comment.