I must add that when I re-built the report RecordSource query, Access tried to establish the links and they were messed up because all tables were included. Too many links were created and I had to clean it up. This probably happens because same field names are used in multiple tables. Might want to modify that.