I'm trying to multiply a user defined length times a user defined width. That product is then defined a number which is to be added to other user defined numbers. For instance,
user entered 5 for length and 5 for width thus query results size of 25. Scale is:
<= 25 add 1
>25 and <30 add 2
>30 and <40 add 3
>40 add 4
This 1,2,3, or 4 then gets added to various other numbers that give me no problems. I guess my question is, can this be written in a query?
user entered 5 for length and 5 for width thus query results size of 25. Scale is:
<= 25 add 1
>25 and <30 add 2
>30 and <40 add 3
>40 add 4
This 1,2,3, or 4 then gets added to various other numbers that give me no problems. I guess my question is, can this be written in a query?