Solved My Switch() function won't work in a report. Can anyone help me?

[danititiriga]

Thanks to everyone for taking time out of their day to help me! I really appreciate it! I will close this thread now.

 

[MajP]

This is why you put data in tables.
The boss wants more fidelity
tblDuration

ID	minDuration	MaxDuration	Message
1​	0​	29​	Less than 30 minutes
7​	30​	31​	Half hour movie
10​	31​	60​	Greater than 30 minutes less than 1 hr
6​	60​	61​	Hour Movie
11​	61​	90​	Greater than 1 hr less than 1.5 hrs
2​	90​	91​	90 minutes
3​	91​	120​	Greater than 90 and less than 120
4​	120​	121​	120 minutes
5​	121​	180​	Greater than 2 hrs less than 3
8​	180​	181​	Painful 3 hour movie
9​	182​	1000​	Whose idea was this

No change to code
Query1

MovieName	Duration	Message
Movie 8	45​	Greater than 30 minutes less than 1 hr
Movie 1	80​	Greater than 1 hr less than 1.5 hrs
Movie 2	90​	90 minutes
Movie 3	92​	Greater than 90 and less than 120
Movie 4	119​	Greater than 90 and less than 120
Movie 5	120​	120 minutes
Movie 6	125​	Greater than 2 hrs less than 3
Movie 9	179​	Greater than 2 hrs less than 3
Movie 10	200​	Whose idea was this