...entries are in the detail tables. So, I know this is not the way to do it. Here's my sql string anyway for reference:
strSQL = "SELECT tblERmain.*, tblERdaily.*, tblERautoMileage.*, tblERentertainment.*, tblERmisc.*, tblERpersonal.*, tblERtravelDetail.*,
tblERledger.* FROM tblERmain INNER...