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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Paul said:
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.
Click to expand...


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?
 
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
 
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
--

Paul said:
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
Marshall Barton said:
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?
Click to expand...
Click to expand...
 
Back
Top