Hello everyone. before we start: I am total newbie to Access (used few times, exited).
Situation: i am trying to analyze data that has too many fields for Excel. Like - 10 right now and it could be NOT enough. Entering data may bring errors. And sometimes I require field connections.
I'm creating a nested Iff statement in a query to return the corresponding cost for each value:
0-500 = 6,48
501-750 = 4,32
751+ = 2,16
2,16 displays correctly for values over 751.
4,32 displays correctly for values 501-750
6,48 displays correctly for values 0-500. HOWEVER! Amongst...