KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a query which includes fields named openingbalance and commissions . I would like to compute values for commissions based on openingbalance , similar to this Select Case block in Access VBA: Select Case OpeningBalance Case 0 To 5000 commission = 20 Case 5001 To 10000 commission = 30 Case 10001 To 20000 commission = 40 Case Else commission = 50 End Select But since Access doesn't allow Select Case in a query, how can I accomplish my goal in Access SQL?
Tags (comma-separated)
Save Edits
Cancel