Report recordsourse issue

[Zilla]

Hi.

I'm not sure the best way to tackle this problem, I think it is a data
structure issue; the report is for displaying info by project, for numerous
different projects visits:

My report duplicates records... I need it to display the info for each
project once, but it does it numerous times 9and takes forever to load). I
understand the reason for this, but I don't know how to avoid it: the record
source query sometimes contains more than one row for each project - hence
duplicates in my report.... simple answer....: "don't have more than one
recordsource row with a project on it!!"

Yes, BUT it is not so simple..... the query is based on a "project List"
table and a "Project Visit" table. Each project can have several visits. The
report needs to display all of the visits to an individual project. But I
can't display each visit as a sub report - the data needs to be intermingled
throughout (which is really the cause of this problem).... and hence the need
for a single unifying query to base my report on.



So: either I have the existing report which is slow and duplicates itself OR
I rearrange my report to allow the data to be broken down into subreports,
(which hte project manager tells me is not an option). Can anyone help me
with a third way?


Thanks

 

[Duane Hookom]

You haven't mentioned anything about primary or foreign keys or provided a
sample of your data. No one can help you without some additional
information.

Duane Hookom
MS Access MVP