dupliacte query

[richard harris]

i have a query (for a report) with a main table and 2 1-many tables. all
joined by the primary key in the main table caseref.

i have a form based upon these and can enter data no problem. the issue i
have is as follows

the query for the report shows 5 records for the client, i have checked each
of the 3 tables and only 1 record for the client exists in each table.
although the 2 many tables can have nore than 1 record, only 1 record exists
so far.

the ongoing problem, is that the report is creating a report for each record
in the query (ie 5 times).

can anyone please help!!!!!

thanks

richard

 

[kingston via AccessMonster.com]

Try creating your joins like this:

Main -> ManyTable1
Main -> ManyTable2

At least this is how it should look in the query that feeds the report.
Don't add any other joins (e.g. ManyTable1 to ManyTable2). If this doesn't
work, you'll have to go into greater detail about your data structure, query,
and report output.

 

[richard harris]

hi kingston,

thanks for your help. my query was set up as you suggested. i have fixed
the issue maybenot in the best way but it certainly has helped.

i created a sub reports for each of the many tables and then deleted these
tables from the query.

not sure if this is the best option but seems to have worked well. thanks
again richard