AnsweredAssumed Answered

Need help creating a relationship against a range of dates

Question asked by mkenglen on Feb 28, 2016
Latest reply on Feb 28, 2016 by 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?


Mary Kay