I have some products that are sold and others that are bought. They are not the same product. For example when I buy beer, I buy a barrel, but when I sell beer, I sell a jug. They are different product codes. I have a table to relate both products.
The report gives me the sales between the 2 selection dates, and what I need to find the price at which a product was purchased before the selected dates.
In the example, in May I sold 7 beer jar, but the last barrel of beer I bought in March and I need to get that price. I managed to get the date of the last purchase, but I can't get the price. In the example the price should be 45. And if I choose february the price should be 40.
I have downloaded your file and everything works fine. But in mine I copy the same formula and it doesn't work. I do not get it. I have also tried to copy the table from one report to another and the data does not come out :-(.
It is very rare. I'm going to make up what's going on. Thank you very much for your help
