Hello, I am new here and fairly new to Access. I'm trying to create a 'scorecard' in which I can assign a value to any given range of data in a table. For example, if Trips is between 0 and 10, assign a value of 0. If between 11-20, assign a value of 1, between 21-30 assign a value of 2, and so on. This will be used across many fields to develop a 'scorecard'. I am having difficulty developing this in Access and would appreciate any input. Thank you!