dayna
Registered User.
- Local time
- Today, 02:57
- Joined
- Nov 10, 2007
- Messages
- 39
And now for another rambling, poorly articulated question from yours truly…
I’m working on a db that, amongst other things, stores schedule information for the various classes that my organization offers at various times. Since different classes meet at different times on different days, and even a different number of days per week, I designed tblClassSchedule as follows:
Schedule ID (PK)
ClassID (FK from tblClasses)
Day (FK from lkpDaysOfWeek)
StartTime
EndTime
This design seems to fulfill its purpose very well when it comes to things like searching and calculating and so forth, but I’m having trouble getting rptClassSchedule to display according to my supervisors’ specs. They don’t like seeing each day that a class meets represented in a separate row and want to see the schedule info in a single row with two columns. So, for example, the schedule for a class that meets Monday through Thursday from 9:00am to 12:00pm appears on my report as:
DAY START TIME END TIME
Monday 9:00am 12:00pm
Tuesday 9:00am 12:00pm
Wednesday 9:00am 12:00pm
Thursday 9:00am 12:00pm
My supervisors want to see something along the lines of:
DAYS TIMES
MTWTh 9:00am – 12:00pm
Of course, I agree that the latter is more aesthetically pleasing, but I can’t seem to figure out how to get there. Is it even possible to concatenate or programmatically abbreviate records from the same field? More specifically, is it conceivable that someone with very modest VBA skills might be able to accomplish this? (I embed some fairly basic event procedures into my forms from design view, but that’s about the extent of it.)
As always, if someone can help me formulate my question in searchable terms, I’m happy to do the research and grunt work myself. If what I’m trying to do is possible, what is it called? If what I’m trying to do isn’t possible, will you kindly end my misery and tell me so? What about a third way: something that gets me closer to my supervisors’ format preferences, but isn’t totally beyond the scope of my abilities? Thanks!
I’m working on a db that, amongst other things, stores schedule information for the various classes that my organization offers at various times. Since different classes meet at different times on different days, and even a different number of days per week, I designed tblClassSchedule as follows:
Schedule ID (PK)
ClassID (FK from tblClasses)
Day (FK from lkpDaysOfWeek)
StartTime
EndTime
This design seems to fulfill its purpose very well when it comes to things like searching and calculating and so forth, but I’m having trouble getting rptClassSchedule to display according to my supervisors’ specs. They don’t like seeing each day that a class meets represented in a separate row and want to see the schedule info in a single row with two columns. So, for example, the schedule for a class that meets Monday through Thursday from 9:00am to 12:00pm appears on my report as:
DAY START TIME END TIME
Monday 9:00am 12:00pm
Tuesday 9:00am 12:00pm
Wednesday 9:00am 12:00pm
Thursday 9:00am 12:00pm
My supervisors want to see something along the lines of:
DAYS TIMES
MTWTh 9:00am – 12:00pm
Of course, I agree that the latter is more aesthetically pleasing, but I can’t seem to figure out how to get there. Is it even possible to concatenate or programmatically abbreviate records from the same field? More specifically, is it conceivable that someone with very modest VBA skills might be able to accomplish this? (I embed some fairly basic event procedures into my forms from design view, but that’s about the extent of it.)
As always, if someone can help me formulate my question in searchable terms, I’m happy to do the research and grunt work myself. If what I’m trying to do is possible, what is it called? If what I’m trying to do isn’t possible, will you kindly end my misery and tell me so? What about a third way: something that gets me closer to my supervisors’ format preferences, but isn’t totally beyond the scope of my abilities? Thanks!