Getting rid of multiple records

[sr71aa]

Hi Folks,

I'm doing a Schedule Adherence Report in Access. One table has the schedule start time and stop time. The second table has exception times (lunches, breaks, etc). Both tables have the common denominator of a unique Schedule ID. How do I bring them together with repetitive Schedule records from the first table. What I get is the following:

ID Code Time Code Time
1 Open 12:00 Break 2:00
1 Open 12:00 Lunch 4:00
1 Open 12:00 Break 6:00

What I want is the following:

ID Code Time Code2 Time Code3 Time Code4 Time
1 Open 12:00 Break 2:00 Lunch 4:00 Break 6:00

Please help,

Rick.

 

[grnzbra]

It appears that all you need is a crosstab query.

 

[sr71aa]

I'm afraid that I was having difficulty with a cross-tab query which is what brought me to this forum in the first place.

 

[grnzbra]

What was the problem? Did you use the wizard?