I have a table that contains component replacement on heavy equipment. I need to run either a query or report or combination of both to calculate hours on the component. Here's the trick. The hours will be calculated based on the hour meter entry of the new component with the newest component...