title: table joins in Access 2003 on date-time field
body: <p>I need to join my data table to a server calendar file (has set fiscal dates, periods, etc.).  I don't get any results and believe it is because my table has date/time like "11/23/2009 11:30:34AM" and the calendar file only has date/time like "11/23/2009", so the fields are not identical.</p>
  
  <p>current SQL reads like:
  From tbl_data
  Inner Join tbl_calendar on tbl_data.TRXdate = tbl_calendar.TRXdate</p>
  
  <p>any ideas?</p>