Guys! I have been working on this TV program guide and got stuck with reporting. Here is my table. I trying to build a query on access to have a report presented as attached image. also I have attached excel file of the table for any helper to work around.
Some help in this regard is much appreciated.
Sid Pid ProgramName AirDate StartTime EndTime
1 201 Kids Crtoon Sunday, October 5, 14 10:00 12:00
2 201 Kids Crtoon Monday, October 6, 14 10:00 12:00
3 201 Kids Crtoon Tuesday, October 7, 14 10:00 12:00
4 201 Kids Crtoon Wednesday, October 8, 14 10:00 12:00
5 201 Kids Crtoon Thursday, October 9, 14 10:00 12:00
6 202 Family Movie Friday, October 10, 14 10:00 14:00
7 203 Movie Marathon Saturday, October 11, 14 11:00 15:00
8 204 Play TV Sunday, October 5, 14 12:00 12:15
9 204 Play TV Monday, October 6, 14 12:00 12:15
10 204 Play TV Tuesday, October 7, 14 12:00 12:15
11 204 Play TV Wednesday, October 8, 14 12:00 12:15
12 204 Play TV Thursday, October 9, 14 12:00 12:15
13 205 Very Original Sunday, October 5, 14 12:15 12:30
14 206 Gone Too Soon Monday, October 6, 14 12:15 12:30
15 206 Gone Too Soon Tuesday, October 7, 14 12:15 12:30
16 205 Very Original Wednesday, October 8, 14 12:15 12:30
17 206 Gone Too Soon Thursday, October 9, 14 12:15 12:30
18 207 Crush Foreign Sunday, October 5, 14 12:30 14:45
19 207 Crush Foreign Monday, October 6, 14 12:30 14:45
20 207 Crush Foreign Tuesday, October 7, 14 12:30 14:45
21 207 Crush Foreign Wednesday, October 8, 14 12:30 14:45
22 207 Crush Foreign Thursday, October 9, 14 12:30 14:45
23 205 Very Original Friday, October 10, 14 14:00 15:00
24 208 International Hits Sunday, October 5, 14 14:45 15:00
25 208 International Hits Monday, October 6, 14 14:45 15:00
26 208 International Hits Tuesday, October 7, 14 14:45 15:00
27 208 International Hits Wednesday, October 8, 14 14:45 15:00
28 208 International Hits Thursday, October 9, 14 14:45 15:00
Some help in this regard is much appreciated.
Sid Pid ProgramName AirDate StartTime EndTime
1 201 Kids Crtoon Sunday, October 5, 14 10:00 12:00
2 201 Kids Crtoon Monday, October 6, 14 10:00 12:00
3 201 Kids Crtoon Tuesday, October 7, 14 10:00 12:00
4 201 Kids Crtoon Wednesday, October 8, 14 10:00 12:00
5 201 Kids Crtoon Thursday, October 9, 14 10:00 12:00
6 202 Family Movie Friday, October 10, 14 10:00 14:00
7 203 Movie Marathon Saturday, October 11, 14 11:00 15:00
8 204 Play TV Sunday, October 5, 14 12:00 12:15
9 204 Play TV Monday, October 6, 14 12:00 12:15
10 204 Play TV Tuesday, October 7, 14 12:00 12:15
11 204 Play TV Wednesday, October 8, 14 12:00 12:15
12 204 Play TV Thursday, October 9, 14 12:00 12:15
13 205 Very Original Sunday, October 5, 14 12:15 12:30
14 206 Gone Too Soon Monday, October 6, 14 12:15 12:30
15 206 Gone Too Soon Tuesday, October 7, 14 12:15 12:30
16 205 Very Original Wednesday, October 8, 14 12:15 12:30
17 206 Gone Too Soon Thursday, October 9, 14 12:15 12:30
18 207 Crush Foreign Sunday, October 5, 14 12:30 14:45
19 207 Crush Foreign Monday, October 6, 14 12:30 14:45
20 207 Crush Foreign Tuesday, October 7, 14 12:30 14:45
21 207 Crush Foreign Wednesday, October 8, 14 12:30 14:45
22 207 Crush Foreign Thursday, October 9, 14 12:30 14:45
23 205 Very Original Friday, October 10, 14 14:00 15:00
24 208 International Hits Sunday, October 5, 14 14:45 15:00
25 208 International Hits Monday, October 6, 14 14:45 15:00
26 208 International Hits Tuesday, October 7, 14 14:45 15:00
27 208 International Hits Wednesday, October 8, 14 14:45 15:00
28 208 International Hits Thursday, October 9, 14 14:45 15:00
