I am trying to develop a query in MS Access 2010 to join two tables using three joins one of which is a (between) date range. The tables are contained in Access.
ABCPART links to XYZPART. ABCSERIAL links to XYZSERIAL. ABCDATE links to (between) XYZDATE1 and ZYZDATE2.
[ABCTABLE] ABCORDER ABCPART ABCSERIAL ABCDATE
[ZYXTABLE] XYZORDER XYZPART XYZSERIAL XYZDATE1 XYZDATE2