Recent content by JustABeginner

Thanks Ridders, What would happen if the MonthStart was not conveniently at the start of a quarter? I'm guessing the solution posted below would only work as long as it does?

Hi, I know that in Excel it is east to return in Approximate Match using Vlookup, but I am struggling to replicate that in Access. I wish to summarise two tables that show the contract month, and the contract price (which changes quarterly): The first table is called TblContractMth ID...

It's been a while since I used Access, but new role = updating my skill set!