Grouping

R

Rob D

I have a report I would like to generate from the following fields:
-Name
-Arrival Date
-Preference 1
-Preference 2
-Preference 3

The table contains about 300 records with a with a table that you can select
the same 12 choices for each preference.

I would like the report to look something like this (simplified):

Preference Report

Preference 1
Name Arrival Date

Preference 2
Name Arrival Date

Preference 3
Name Arrival Date

The query is asking for a specific entry (for example Shipping Department)
and searching each of the preference fields for it.

Be easy with me, I am a self taught Access user!!! Thanks for your help!
 
Top