Liveware Publishing Support Forum

When trying to join MS Access tables using R&R SQL version 9.0, the default setting is to skip the record if no match is found. If I try to change the setting to include unmatched records, I get a "not supported by MS Access" error. For me this is a critical problem in that I frequently audit tables where some of the fields I am trying to join are blank. What I want is for R&R to return the blank field. If the field is blank R&R drops the entire record.____In R&R Xbase version 8.0 you have the option to "blank" the field. What happened to this option?

The problem you are seeing is that R&R^s auto SQL does not allow you to include an unmatched record join in an Access report that includes more than one join.____The workarounds are to built a query in Access that does the table joins and then report on that table or to create a User SQL report where you write the SELECT statement and can manually create the appropriate join syntax.____This issue is mentioned in the readme file for Version 9.____Kathleen __R&R Support