Records reported 69 times

[Bob Griendling]

I'm using Access 2007 w/ XP.

I have a report I've used for year that groups records and provides
sub-group totals. As I was looking at the design of the table to which the
source for the report, I may have inadvertently clicked something because
when I run the report, each record from the query upon which the report is
based is reported 69 times. I've checked the query and it looks good.

I don't use Access that often, so I'm feeling like a beginner here.

Any suggestion on what might be happening.

Bob

 

[Marshall Barton]

I'm using Access 2007 w/ XP.

I have a report I've used for year that groups records and provides
sub-group totals. As I was looking at the design of the table to which the
source for the report, I may have inadvertently clicked something because
when I run the report, each record from the query upon which the report is
based is reported 69 times. I've checked the query and it looks good.

I don't use Access that often, so I'm feeling like a beginner here.

Sounds like a problem in the report's record source query.
If you'll post a Copy/Paste of the query's SQL view maybe
someone might be able to spot the problem.

 

[Bob Griendling]

As requested here's what I think you want, i.e., the a Copy/Paste of the
query's SQL view:

SELECT [Health Insurance].Type, [Health Insurance].[Toward Deductible],
[Health Insurance].Provider, [Health Insurance].[Out of Pocket], [Health
Insurance].[Date of Service]
FROM [Health Insurance], [Mom's Health Insurance]
WHERE ((([Health Insurance].[Date of Service])>=#1/1/2009# And ([Health
Insurance].[Date of Service])<=#12/31/2009#));

 

[Bob Griendling]

That was it. Thanks so much. I thought that having taken out of the query
all records related to [Mom's Health Insurance] there was no connection.
But like I said, I no longer use Access enough to troubleshoot as well as I
should.

Thanks, again.

Bob

SELECT [Health Insurance].Type, [Health Insurance].[Toward Deductible],
[Health Insurance].Provider, [Health Insurance].[Out of Pocket], [Health
Insurance].[Date of Service]
FROM [Health Insurance], [Mom's Health Insurance]
WHERE ((([Health Insurance].[Date of Service])>=#1/1/2009# And ([Health
Insurance].[Date of Service])<=#12/31/2009#));

My money is on the second table. in the FROM clause. Take that out and
the
comma. My bet is that the [Mom's Health Insurance] table contains 69
records,
because without join criteria, you've created a cartesian product.
(returns
one record for every combination of the primary keys of the two tables).