Group Report

[Guest]

I have a table with 4 fields: Name1, Entre'e1, Guest Name and Guest Entre'e.
I want to create a report group by Entre'e.
Here are some sample records:
Name1, Entre'e1, Guest Name, Guest Entre'e
John, Beef, Mary, Fish
Paul, Fish, Linda, Chicken
Sam, Beef, Karen, Beef.
The report should look like this:
Beef
John
Sam
Karen
Chicken
Linda
Fish
Mary
Paul

How can I do this in report and what kind of query I should create? Thanks.

 

[Duane Hookom]

First, normalize your data by creating a union query
SELECT Name1 as Diner, Entre1 as Entre, 1 as Num
FROM tblWith4Fields
UNION ALL
SELECT GuestName, GuestEntre, 2
FROM tblWith4Fields;

Change the field names to match your field names.

Then create a report based on the union query and set the first sorting and
grouping level to Entre.

--
Duane Hookom
MS Access MVP

I have a table with 4 fields: Name1, Entre'e1, Guest Name and Guest Entre'e.
I want to create a report group by Entre'e.
Here are some sample records:
Name1, Entre'e1, Guest Name, Guest Entre'e
John, Beef, Mary, Fish
Paul, Fish, Linda, Chicken
Sam, Beef, Karen, Beef.
The report should look like this:
Beef
John
Sam
Karen
Chicken
Linda
Fish
Mary
Paul

How can I do this in report and what kind of query I should create?

Thanks.