Need a report or query(?)

I have a table of class information that contains class name, start date,
instructor, start time and days held - the days held (if more than one day)
repeat in separate records.

I need to end up with one record per class that shows class name,
instructor, start date and the days and times held. (Also in the mix is that
times held can be different each day held.)

Where do I start? A query? Two queries?

I started by creating a table and grouping on class name so I have a table
with non-dup class names...now, I am dead in the water!

Thanks in advance!

On Tue, 18 May 2010 08:45:01 -0700, PeggyG
wrote:

I have a table of class information that contains class name, start date,
instructor, start time and days held - the days held (if more than one day)
repeat in separate records.

I need to end up with one record per class that shows class name,
instructor, start date and the days and times held. (Also in the mix is that
times held can be different each day held.)

Where do I start? A query? Two queries?

I started by creating a table and grouping on class name so I have a table
with non-dup class names...now, I am dead in the water!

Thanks in advance!

Tables store data.

Queries (based on tables) select, combine, and arrange data.

Reports (based on queries) print data.

You need all three, but you certainly do not want to create a new table just
for this information. You would create a Query based on the table of class
information, and base a Report on that query, I would guess; you can use the
Report's Sorting and Grouping feature to let you put class name and instructor
and so on in a Header and the details of individual class sessions in a Detail
section.
--

John W. Vinson [MVP]