Records reported 69 times

  • Thread starter Thread starter Bob Griendling
  • Start date Start date
B

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


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

PieterLinden via AccessMonster.com said:
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#));
Click to expand...

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).
Click to expand...
 
Back
Top