Caclulation on linked field


I’m doing some work for a children’s nursery have a field called “RATE PER HR” in the table STUDENT it is a currency and linked to a table called RATE. I need to do a simple calculation RATE PER HR * NUMBER OF HOURS I’m unable to do this without getting an error in the field. What am I doing wrong, how do I get around this ?



Welcome to the community, @Jason_Martin! :smiley: Sorry that your question has gone unanswered for so long. Were you able to get this working?