Ok, this is a strange one

[trackmedic]

I have a query built off of a table and subtable. the report that is generated worked fine until I added another field from another subtable.

The new field shows "visitors" there can be up to four visitors at a time recording info.

Now, the query shows four identical entries for visitors. the report is also doing the same thing.

how can I fix the query to not show repetative stuff. Also, how can I fix the report if anyone know how to do that!?!?!

Thanks in advance.

 

[boblarson]

1. Did you link the tables together in the query (no links will give you a Cartesian product - one record times the number of records in the other table).

2. If the other field you added is from a table which is the Many side of a one to many you will get a record for each record in the many side with the details of the one side duplicated for as many records as there are in the many side.

 

[trackmedic]

That is what is happening. In the query the link is per record and the other subtable "visitors" is the many side of a one to many.

 

[boblarson]

Then it is functioning properly. If you don't want that, then you have to use a subreport for the many side (using it's own query and linked by the appropriate ID field in the master/child links) OR using the Report's Grouping abilities you can do it without the sub report. But you would need to add an appropriate grouping level.