G
Guest
Being new to access, I used the Query builder to identify the field list in
Report Generator. I'm creating a report in Report Generator that pulls across
multiple tables. As many as 8. When I get to the sixth table, it causes the
links to come up with an error. 5 tables is fine and everything links
correctly, when I add the sixth, all the links on the report #error
Here is the SQL statement:
SELECT TPhysicians.TFirstName, TPhysicians.TLastName, TPhysicians.TTitle,
Client.[Client Name], Attendees.AttendeeFirstName,
Attendees.AttendeeLastName, Attendees.[Claim Number], Attendees.[Date of
Loss], Attendees.CaseNumber, Registration.[Date Scheduled],
TPhysicians.TAddress, TPhysicians.TCity, TPhysicians.TState,
TPhysicians.TZip, TPhysicians.TAddress2, Events.EventName, Attendees.[Type of
Coverage], Registration.Specialty, Attorney.Attorney, Attorney.Address,
Attorney.City, Attorney.State, Attorney.Zip FROM (((TPhysicians INNER JOIN
Attendees ON TPhysicians.TPhysicians =
Attendees.TPhysicians) INNER JOIN (Registration INNER JOIN Events ON
Registration.EventID = Events.EventID) ON Attendees.AttendeeID =
Registration.AttendeeID) INNER JOIN Client ON Attendees.ClientID =
Client.ClientID) INNER JOIN Attorney ON (Client.ClientID =
Attorney.ClientID) AND (Attendees.Attorney = Attorney.Attorney);
Report Generator. I'm creating a report in Report Generator that pulls across
multiple tables. As many as 8. When I get to the sixth table, it causes the
links to come up with an error. 5 tables is fine and everything links
correctly, when I add the sixth, all the links on the report #error
Here is the SQL statement:
SELECT TPhysicians.TFirstName, TPhysicians.TLastName, TPhysicians.TTitle,
Client.[Client Name], Attendees.AttendeeFirstName,
Attendees.AttendeeLastName, Attendees.[Claim Number], Attendees.[Date of
Loss], Attendees.CaseNumber, Registration.[Date Scheduled],
TPhysicians.TAddress, TPhysicians.TCity, TPhysicians.TState,
TPhysicians.TZip, TPhysicians.TAddress2, Events.EventName, Attendees.[Type of
Coverage], Registration.Specialty, Attorney.Attorney, Attorney.Address,
Attorney.City, Attorney.State, Attorney.Zip FROM (((TPhysicians INNER JOIN
Attendees ON TPhysicians.TPhysicians =
Attendees.TPhysicians) INNER JOIN (Registration INNER JOIN Events ON
Registration.EventID = Events.EventID) ON Attendees.AttendeeID =
Registration.AttendeeID) INNER JOIN Client ON Attendees.ClientID =
Client.ClientID) INNER JOIN Attorney ON (Client.ClientID =
Attorney.ClientID) AND (Attendees.Attorney = Attorney.Attorney);