Accessing different field when using rollup


#1

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