Left join syntax error in MS Access
Posted: Thu Jan 31, 2002 4:40 pm
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