Access 2007: How can I make this EXPRESSION less complex?
- by Mike
Access is telling me that my new expression is to complex. It used to work when we had 10 service levels, but now we have 19! Great!
My expression is checking the COST of our services in the [PriceCharged] field and then assigning the appropriate HOURS [Servicelevel] when I perform a calculation to work out how much REVENUE each colleague has made…