Query limitation

[Zanstemic]

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);

 

[Sylvain Lafontaine]

Are you talking about an ADP project (this newsgroup) or a MDB file?

However, in both cases, I would be surprised that the limit for the Query
builder is only five tables but still, you should ask in a more appropriate
newsgroup than this one.

In all cases, you should learn to go into text mode and type yourself the
queries that you need as you cannot make any complicated thing with the
Query Builder. (Even a simple Union won't work with the Query Builder.)

 

[Zanstemic]

I'll move it to a more appropriate group and not surprised by the advice.

Are you talking about an ADP project (this newsgroup) or a MDB file?

However, in both cases, I would be surprised that the limit for the Query
builder is only five tables but still, you should ask in a more appropriate
newsgroup than this one.

In all cases, you should learn to go into text mode and type yourself the
queries that you need as you cannot make any complicated thing with the
Query Builder. (Even a simple Union won't work with the Query Builder.)

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

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);