Duplicate data removed from reports?

[DAB]

I have a report that is created from a query. It selects Last Name, First
Name and the data for each field of the report. If there are two last names
such as Smith the query lists all the Smiths but when I run the report it
only selects the first Smith listed in the query and "hides" the remaining
Smiths. This worked fine in Access 2000, that is what I created the database
in. I have looked at filters but cannot find any in 2007 that would appear
to be causing this fault. The report Sorts on Last Name, then First Name
then a value in another field which all work.
Any help would be appreciated.

 

[Jeff Boyce]

Doug

Check the control that holds LastName in the report (in design view). Check
the properties of that control ... does it have "Hide duplicates" turned on?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DAB]

Thanks for the tip but Hide Duplicates is set to No. I have the Last Name
and First Name in the Last Name Header Grouping while the rest of the data is
contained in the Detail area of the Report. I tried moving the Last Name and
First Name to the Detail area but then it totals all the data for everyone
with the same last name but does group by name. It's interesting that the
Grouping by Last Name and First Name does not work in the Header areas of the
Report.

 

[Jeff Boyce]

Doug

If you want a LastName + FirstName grouping, one way to do this is back in
your query -- concatenate the two together in a new field and feed that to
your report.

Regards

Jeff Boyce
Microsoft Office/Access MVP