users with the same name being grouped in report.

[Lionrampant]

Hi there,

I am having a problem with access 2003.

when i am running a query for our billing report, clients are all displayed individually with the correct totals next to their name. However when I run a billing report, clients with the same surname are being grouped together and the values for these clients are being totaled rather than itemised separately like they are in the query.

I have check that hide duplicates is not active. does anyone have any other ideas?

Thanks in advance.

SF.

 

[KenHigg]

Is the surname being stored in one of the name fields?

 

[ideefixe]

I would design a query with an expression field concatenating both name and surname - and maybe writing a little function that will do that for you.

e.g. SELECT CombineTwoFields(Table.Firstname,Table.Surname) AS FullConcatName

Use that query to drive the report and then you can change the design to group by the FullConcatName rather than both names, if you make sure it's ordered by surname first.

Hope this helps.

 

[modest]

Group by client Id not name