Search results

In a field on a form I am trying to retrieve the latest pricing information based on the newest date. tblChecklistPricing pkCardID curCardBVPrice dtmCardPricingC 585 1.00 4/14/2019 586 1.25 4/14/2019 588 1.25 4/14/2019 585 1.50 4/16/2019 So in the example above, I would like to display "1.50"...