Grouping Order Question
In my database we keep office information for people. What I want to do is to take the fax number from office a, b, c, and have vertically next to each other..and then do the same thing for the phone number, address etc. Instead, I am getting all of office a information, then all of b, etc. I've tried changing what I am grouping by and adding additional groups, I can't seem to find a solution. Any help would be appreciated. Thank you.
Why do you need groups at all? I would think the report is simply
[fax number] [phone number] [address] ...
with fields listed across the page, one line per office.
Groups are used to show multiple records with the same value in a given field together. For example, if you were listing the employees in each office, you'd probably want to group by office, so all employees in the same office are listed together. You could then show the office fax, phone and address only once for all of those employees.
If there's still a question, please reply to my last post's request for sample data and desired result.