7 Replies Latest reply on Feb 28, 2016 12:10 PM by mkenglen

    Need help creating a relationship against a range of dates

    mkenglen

      Good Morning.

      I have two tables that I'm trying to create related field for:

      one that manages events that employees travel to. It contains their event start date and the mileage to the event.

      the other table contains IRS mileage reimbursement data for a particular date rang (i.e. from 1/1/15 to 6/30/15).

      I'm having trouble figuring out how to relate the two so that: if the event start date falls within a certain date range in the IRS Mileage table, I could then bring over the IRS mileage figure that relates to the event start date.

       

      Can someone point me in the right direction?

      Thanks!

      Mary Kay