G
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
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