Merge feilds

[Guest]

I have an ID that is unique that could show 2 times because of locations in
one table. The ID sow in another table 7 times, to record the ID office hours
in the week days. How can I make all these entries in one feild.

Table 1
ID LOCNUM
1 LOC1
1 LOC2
2 LOC2

Table 2
ID LOCNUM DAY OFFICEHOURS1 OFFICEHOURS2
1 LOC1 M 9-5
1 LOC1 T 9-2 2-5
1 ---- W 10-12 1-5
...... And so on for each day.

How can I put them all together in a report in one feild? or any other
solution that will make it presentable in a report.

Thanks

 

[Duane Hookom]

I would create a union query to normalize table 2. Then create a report
based on one of the samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4