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

[Guest]

My Query works correctly showing 52 items. The Report duplicates and
multiplies the contents of the Query, giving 2457 items or on another
occasion 741. What can I do?
Cheers, Paul

 

[Marshall Barton]

My Query works correctly showing 52 items. The Report duplicates and
multiplies the contents of the Query, giving 2457 items or on another
occasion 741.

Are you sure the report uses that same query?
If it is, what, exactly, is the query's SQL?
Does the report have a subreport?
If there is a subreport, what is its record source?

 

[Guest]

Hi Marshall, As far as I understand the report uses the same query
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));
The report has no subreport
Cheers ,Paul

 

[Duane Hookom]

Why do you have the [Postal Addresses] table in your query twice? Try change
your sql to:
SELECT [Postal Addresses].[First name], [Postal Addresses].[Family Name],
[Postal Addresses].[Ticket/s Sent]
FROM [Postal Addresses]
WHERE ((([Postal Addresses].[Ticket/s Sent])=True));


--
Duane Hookom
MS Access MVP
--

Hi Marshall, As far as I understand the report uses the same query
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));
The report has no subreport
Cheers ,Paul

Are you sure the report uses that same query?
If it is, what, exactly, is the query's SQL?
Does the report have a subreport?
If there is a subreport, what is its record source?