Join two tables, Based on two fields in each

[Ted Allen]

Hi Robert,

I believe that you should be able to do this by adding a
calculated field with the following entry that will give
you the number of hours between the two date/time values:

HourDifference: Abs((Schedule.Date_Time-
Conference.Date_Time))*24

Then, just enter <=5 for the criteria.

Post back if this doesn't work.

-Ted Allen

 

[Ted Allen]

Oops,

For some reason in my initial response I was thinking
that you wanted all within 5 hours, instead of one, not
sure how I got that in my head. Anyway, if you did use
this method the criteria would be <=1, not 5. John
Spencer and John Vinson also posted other methods that
may be better, or at least more clear to others in the
future as to what it is doing.

-Ted Allen