Report header questions

[Guest]

I have a report, based on a query that extracts data from just one table.

The query captures an ID field, LName, FName, and several other fields.

If there are separate entries for Smith, John and Smith, Mary I get one
report entry for Smith, John and no report for Smith, Mary. I know that the
query retrieves entries for both John and Jane, but the report groups them
together. I've tried working with the "Sorting and Grouping" part, but have
not been successful.

How can I separate the entries?

tia,

 

[Marshall Barton]

I have a report, based on a query that extracts data from just one table.

The query captures an ID field, LName, FName, and several other fields.

If there are separate entries for Smith, John and Smith, Mary I get one
report entry for Smith, John and no report for Smith, Mary. I know that the
query retrieves entries for both John and Jane, but the report groups them
together. I've tried working with the "Sorting and Grouping" part, but have
not been successful.

You can use an expression to group on, e.g.
=LName & ", " & FName

Or maybe you'd be better off first sorting on LName and then
Grouping on ID.

 

[Guest]

thank you. I didn't know one could use that type of code there. It worked
just like it should.

JMorrell