Duplicate data on reports

[Karen]

Hi.

I have a report that is based on a make table query. The make table query
result is as follows:

parent id last paternal id maternal id
0010121 Basch 0022976 0042020
0010121 Basch 0022976 0048999
0010121 Basch 0045564 0042020
0010121 Basch 0045564 0048999
0010121 Basch 0094058 0042020
0010121 Basch 0094058 0048999

I need my report to look like this:
parent id last paternal and maternal id
0010121 Basch 0022976
0045564
0094058
0042020
0048999

The parent id and last name comes from a make table query of its own. The
maternal and paternal id's come from two seperate make table queries. All
tables ar joined by the parent ID as it exists in all 3 tables. The parent
ID table is the "parent" and the two other tables are the "child" (in join)

I tried "hide duplicates" property to "yes" and it does not work because I
have other people on my report with the same last name and it is hiding them
as well.

I hope this is clear and you can help.
Thanks

 

[Maurice]

Karen,

Have you tried the options 'Show duplicates' on the properties of the
report? You can set this option to no. Maybe that will give you a simple
solution...

Maurice

 

[Duane Hookom]

A report can't really be based on a "make table query". I expect your report
is based on a query or table or SQL statement.

You must sort/group on some unique value for the Parent. This might be an
expression like:
=[LastName] & [Parent ID]
Display the Group Header for this level and place controls in it for Parent
ID and LastName.

Find the On Format event property for this section and Build some Code.
Enter code of:
Me.MoveLayout = False