Hello i have a DB called week numbers it consists of a order number and 52 fields from Week Number1 to 52. I also have various forms, sub forms and query's. What i am after for each order number the first week from left to right that contains a value (number field), once a value if round the result would be the week number that that value is in, Example
Order Number Result
1 Week 10
2 Week 8
3 Week 45
4 Week 50
Order Number Result
1 Week 10
2 Week 8
3 Week 45
4 Week 50