Hi Folks, I'm very new to Access so please explain any answer in full for which I thank you in advance.
I have a field in Table 'Bookings' that contains a lookup to choose one of 5 or 6 choices of cleaning service for property owners to provide to their holidaymaker renters. So the field ends up with a number (which I could change to a character value or to a letter, a, b c etc.).
Later in the record entry I want to be able to assign a cost to the owner and a payment to the cleaner in two further fields.
So a lookup or query that is accessed from the data entry field would be ideal. The lookup/query would produce a list with the 'Cleaning' numbers in, and a description of the level of service. Upon clicking a choice, the 'CleanersPay' field and the 'ChargeOwner field in the 'Bookings' table would be filled with the €s amount.
I've tried with nested IIf function and a lookup, but I think there may be a problem with mixing character with number - DeliaPay: IIf([Limpieza]="1",20,IIf(Limpieza]="2",30,IIf([Limpieza]="3", 40, 10)))
I hope I have explained adequately what I am looking for clues about.