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

danititiriga

New member
Local time
Today, 12:21
Joined
May 20, 2020
Messages
9
Thanks to everyone for taking time out of their day to help me! I really appreciate it! I will close this thread now.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:21
Joined
May 21, 2018
Messages
8,463
This is why you put data in tables.
The boss wants more fidelity
tblDuration

IDminDurationMaxDurationMessage
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

MovieNameDurationMessage
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
 

Users who are viewing this thread

Top Bottom