I used to go into view Debug Window in the older version of Access, but I can't find this in the new version of Access. Does such a thing exist?
I want to test the following:
Public Function PRICE_RANGE(PRICE)
'TAKES A PRICE AND CATEGORIZES IT IN ONE OF THE FOLLOWING RANGES.
Dim PRICE
If PRICE <= 10 Then
PRICE_RANGE = "$10.00 AND BELOW"
ElseIf PRICE > 10 And PRICE <= 20 Then
PRICE_RANGE = "$10.01 TO $20.00"
ElseIf PRICE > 20 And PRICE <= 30 Then
PRICE_RANGE = "$20.01 TO $30.00"
ElseIf PRICE > 30 And PRICE <= 40 Then
PRICE_RANGE = "$30.01 TO $40.00"
ElseIf PRICE > 40 And PRICE <= 50 Then
PRICE_RANGE = "$40.01 TO $50.00"
Else
PRICE_RANGE = "OVER $50.00"
End Function
I used to be able to go into the debug window, type:
print price_range(15) <enter>
The debug window would give me an answer based off my code.
I want to test the following:
Public Function PRICE_RANGE(PRICE)
'TAKES A PRICE AND CATEGORIZES IT IN ONE OF THE FOLLOWING RANGES.
Dim PRICE
If PRICE <= 10 Then
PRICE_RANGE = "$10.00 AND BELOW"
ElseIf PRICE > 10 And PRICE <= 20 Then
PRICE_RANGE = "$10.01 TO $20.00"
ElseIf PRICE > 20 And PRICE <= 30 Then
PRICE_RANGE = "$20.01 TO $30.00"
ElseIf PRICE > 30 And PRICE <= 40 Then
PRICE_RANGE = "$30.01 TO $40.00"
ElseIf PRICE > 40 And PRICE <= 50 Then
PRICE_RANGE = "$40.01 TO $50.00"
Else
PRICE_RANGE = "OVER $50.00"
End Function
I used to be able to go into the debug window, type:
print price_range(15) <enter>
The debug window would give me an answer based off my code.