Report based on Query of 52 items duplicates to make 2457....

[Guest]

Hi Marshall, the SQL is SELECT [Postal Addresses].[First name], [Postal
Addresses].[Family Name], [Postal Addresses].[Ticket/s Sent]
FROM [Postal Addresses], [Postal Addresses] AS [Postal Addresses_1]
WHERE ((([Postal Addresses].[Ticket/s Sent])=True)); To my knowledge the
Report is only based on this Query and there are no sub-reports.
Cheers, Paul

 

[John Vinson]

Hi Marshall, the SQL is SELECT [Postal Addresses].[First name], [Postal
Addresses].[Family Name], [Postal Addresses].[Ticket/s Sent]
FROM [Postal Addresses], [Postal Addresses] AS [Postal Addresses_1]
WHERE ((([Postal Addresses].[Ticket/s Sent])=True)); To my knowledge the
Report is only based on this Query and there are no sub-reports.
Cheers, Paul

You're joining the postal addresses table to itself by a Cartesian
Join. Just remove the second instance:


SELECT [Postal Addresses].[First name],
[Postal Addresses].[Family Name],
[Postal Addresses].[Ticket/s Sent]
FROM [Postal Addresses]
WHERE ((([Postal Addresses].[Ticket/s Sent])=True));


John W. Vinson[MVP]