Left join syntax error in MS Access

[RouteView]

If I create an Auto-SQL report specifying a left join between two tables, MS Access objects to the select statement created by R&R when the report is generated. If I use Access to create an SQL Select that it likes, R&R objects when I try to use it it in a User-SQL report.____Are there any solutions besides using the ^query as table^ work-around suggested in a previous post? I realize that it may work, but it requires synchronization between the report and the database, a fragile link that will eventually fail in the field. Also, I will need to make a query for each set of tables that I want to use in reports.____Thanks,__Jonathan

[kfleming]

What is the user SQL statement that you have entered and what error do you get?____Kathleen__R&R Support