Skip to main content

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

Be the first to reply!

Reply