E
essseeproductions
Hi, basically im trying to enter the following into a Query title. It
seems to paste correctly but then part at the end gets deleted when i
click away. I assume this is because there is a limit?
If so can anybody suggest away around my complex formula because it is
very large. (Maybe another method/forumla/re-arrange etc) See below:
Current Grade: Switch([City]=London,IIf([Pop] Between 1 And 3,"Small",
IIf([Pop] Between 3 And 5,"Med", IIf([Pop] Between 5 And 7,"Large"))),
[City]=Rome,IIf([Pop] Between 1 And 3,"Small",IIf([Pop] Between 3 And
5,"Med",IIf([Pop] Between 5 And 7,"Large"))))
Note: The actual formula contains about 5 more cases of cities and is
therefore much longer, hence why i think there is a limit. I have cut
it down to make it easier to read and understand.
Many thanks in advance to all help recieved it is greatly appreciated.
seems to paste correctly but then part at the end gets deleted when i
click away. I assume this is because there is a limit?
If so can anybody suggest away around my complex formula because it is
very large. (Maybe another method/forumla/re-arrange etc) See below:
Current Grade: Switch([City]=London,IIf([Pop] Between 1 And 3,"Small",
IIf([Pop] Between 3 And 5,"Med", IIf([Pop] Between 5 And 7,"Large"))),
[City]=Rome,IIf([Pop] Between 1 And 3,"Small",IIf([Pop] Between 3 And
5,"Med",IIf([Pop] Between 5 And 7,"Large"))))
Note: The actual formula contains about 5 more cases of cities and is
therefore much longer, hence why i think there is a limit. I have cut
it down to make it easier to read and understand.
Many thanks in advance to all help recieved it is greatly appreciated.