Relating tables DateTimes that have uneven times (1 Viewer)

[Cookie_Crum]

Hey,

I'm trying to relate three tables within Access and I'm having some trouble. Each of the three tables has a DateTime column, however I want
to relate each record to the day and not the time (one table will have three entries to a day while another may have 1 or 2). The purpose of this is
so that I can then create a report that can display related columns.

Thanks!

 

[Pat Hartman]

You can extract the Date part of a date/time field with the DateValue() function.