SQL restructured when trying to open a report

  • Thread starter Thread starter Daniel S
  • Start date Start date
D

Daniel S

I have created a query in SQL that performs a left join
on a table of students and a select statement

The query works correctly when viewed on screen, but when
I try to use the query as the record source of a report,
it is rewritten by MS Access, and subseqentially doesn't
work.

Any ideas how to get round this one!
 
You might want to give us something to evaluate.
-what is your original sql
-what is in the rewritten sql
-what do you mean by "doesn't work"
 
Note: this question also has been posted (multi-, not cross-) in
m.p.a.queries. I posted a reply asking for more info just as Duane has done
it.

I vote that we continue the thread here and abandon the one in
m.p.a.queries.
 
Back
Top