I have a Table named Royalty Percentages with fields: Item Number, Royalty to, Royalty Percentage. Each item number has 1-4 records, depending on number of individuals who are paid royalties for the item.
I have a second Table named Net Sales with fields: Item Number, MonthYear, Net Sales. There will be one record for each item number per month.
I want to create a table of Royalty amounts to be paid each month. I am, apparently, a terrible script writer. I am also about to lose my mind (what's left of it). Anyone want to come to my rescue? Thanks!