I would like help with MS access iif statement. I want to group courses but day offered e.g Monday, Tuesday, Wednesday, etc and by time offered e.g Monday: 6:00 PM - 9:20 PM.
I have an iif statement which should convert the letter (day) to worrd e.g, M to Monday etc. Now I want 6 iif statements to convert the rest of the days T, W, H, F, S, Su to Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday. After that I want to arrange the courses by day and time.
Thanks.
okaymy1112
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.