Can't represent join in design view...

  • Thread starter Thread starter Bongard
  • Start date Start date
B

Bongard

I have a query that is join to tables on date fields in the diferrent
tables. If I click to run the query it runs just fine and produces
data correctly. However, if I try to go into design view it says
"Microsoft Office Access can't represent the join expression
MaxReturns_1501.FinishX=tbl_FactSetPerformance.Finish in Design View."
Once I click ok it brings me into design view and erases the join ???
Then of course when I try to close it asks me if I want to save
changes because it has just deleted my join. What is going on here? If
the query can run successfully then why can't it represent the join?
What does that mean and how can I prevent from getting this message
everytime I try to go into design view the query?

Thanks,
Brian
 
I have a query that is join to tables on date fields in the diferrent
tables. If I click to run the query it runs just fine and produces
data correctly. However, if I try to go into design view it says
"Microsoft Office Access can't represent the join expression
MaxReturns_1501.FinishX=tbl_FactSetPerformance.Finish in Design View."
Once I click ok it brings me into design view and erases the join ???
Then of course when I try to close it asks me if I want to save
changes because it has just deleted my join. What is going on here? If
the query can run successfully then why can't it represent the join?
What does that mean and how can I prevent from getting this message
everytime I try to go into design view the query?

Thanks,
Brian
Click to expand...

SOLVED! I went back into the query in design view and recreated all 4
joins. I had two date joins that were acting up and two that were ok.
I made sure to drag the join from the left table to the right every
time and this seemed to work. When I added the two last joins in I
must have tried to make the query look to tbl1 first then pull from
table to for the first two joins -- then with the last two date joins
I must have dragged them the opposite direction making the query look
to table 2 first then table one.

Hope this can help someone else too!
 
Back
Top