By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Group by date

P: 8
I have a query with the following columns, Course ID, Title, Start time, Ending Time, day (when each course is taught.. Monday through Sunday).
Now I want to group the course by Time of Day and Day offered. E.g
Monday Course Time of Day
Math 6:30PM - 9:00 PM
Bio 3:15 PM - 6:00 PM
Tuesday same

Or is it possible to have a table format where I have time of day for each day and courses offered on that particular time showing on the table for different days and course?
Please help

Thanks
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,669
I have a query with the following columns, Course ID, Title, Start time, Ending Time, day (when each course is taught.. Monday through Sunday).
Now I want to group the course by Time of Day and Day offered. E.g
Monday Course Time of Day
Math 6:30PM - 9:00 PM
Bio 3:15 PM - 6:00 PM
Tuesday same

Or is it possible to have a table format where I have time of day for each day and courses offered on that particular time showing on the table for different days and course?
Please help

Thanks
This is one thing I need clarification on. Is the [Time of Day] Field a combination of the [Start Time] and [Ending Time] Fields namely:
Expand|Select|Wrap|Line Numbers
  1. [Time of Day]: [Start Time] & " - " & [Ending Time]
Sep 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.