Report header questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
JMorrell said:
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.
Click to expand...

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.
 
thank you. I didn't know one could use that type of code there. It worked
just like it should.

JMorrell
 
Back
Top