Hi,
I have two tables - Item - has many ItemPriceHistory (ItemName, Price & Date fields)… I want to do a rollup column on Item - CurrentPrice that returns the Price field of the most recent row - any ideas?
I tried this post… Most Recent Date from another table but only returns me the date, not the price - am I being dim?
Thanks,
Andrew