Preventing Duplicate Records

[Dacho]

I am trying to create a report that combines data from multiple tables, some have a single datum per key id, others have many (one to many).


I have a table with drill hole (example. drill hole 1) data that has many fields but only one datum per field. the data is divided by intervals 0-10 ft, 10-20 ft, etc.

In another table the intervals are divided further, 0-1 ft, 1-2ft, etc. with data per each interval.

when i try to create a report i want to show the data based on the 0-10ft intervals, and want to combine from the second table, although theres is more than one record per key ID

I want to create a report that in therory looks like this:

(IMAGINE THE LETTERS ALIGNED TO THE RIGHT)
record 1, drill hole 1 (0-10) a
b
c
d

record 2, drill hole 2 (10-20) a
b
c
d
but instead it looks like this

record 1, drill hole 1 a
record 1, drill hole 1 b
record 1, drill hole 1 c
record 1, drill hole 1 d
record 2, drill hole 1 a
record 2, drill hole 1 b
record 2, drill hole 1 c
record 2, drill hole 1 d
etc


Thanks in advance

 

[sviggos]

I am trying to create a report that combines data from multiple tables, some have a single datum per key id, others have many (one to many).


I have a table with drill hole (example. drill hole 1) data that has many fields but only one datum per field. the data is divided by intervals 0-10 ft, 10-20 ft, etc.

In another table the intervals are divided further, 0-1 ft, 1-2ft, etc. with data per each interval.

when i try to create a report i want to show the data based on the 0-10ft intervals, and want to combine from the second table, although theres is more than one record per key ID

I want to create a report that in therory looks like this:

(IMAGINE THE LETTERS ALIGNED TO THE RIGHT)
record 1, drill hole 1 (0-10) a
b
c
d

record 2, drill hole 2 (10-20) a
b
c
d
but instead it looks like this

record 1, drill hole 1 a
record 1, drill hole 1 b
record 1, drill hole 1 c
record 1, drill hole 1 d
record 2, drill hole 1 a
record 2, drill hole 1 b
record 2, drill hole 1 c
record 2, drill hole 1 d
etc


Thanks in advance

why dont you create a query for all the details that you want to put in your report, and then create a criteria in order to print the exact records? if need any help ask