If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report header questions
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 |
#2
|
|||
|
|||
JMorrell wrote:
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. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
thank you. I didn't know one could use that type of code there. It worked
just like it should. JMorrell "Marshall Barton" wrote: JMorrell wrote: 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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timely: How do I add a date range query for a report? | David | Setting Up & Running Reports | 7 | September 15th, 2004 07:22 PM |
Sub Report | XeniaEagle | Setting Up & Running Reports | 3 | September 9th, 2004 06:36 PM |
Working with the Report Header | WMD | Setting Up & Running Reports | 4 | June 11th, 2004 08:49 PM |
Report Header in Mailing Labels... | Grim Reaper | Setting Up & Running Reports | 2 | June 9th, 2004 04:25 AM |
Center header image horizontally in report | dw | Setting Up & Running Reports | 3 | May 27th, 2004 05:58 PM |