I need some assistance with modifying a query in MS-Access. Please find attached sample database. It contains the following:
1. "tblSourceData_1" with the following fields: [ID], [Time], [Owner]:
- Table contains 5 records
2. "tblSourceData_2" with the following fields: [ID], [Time], [Owner]:
- This table is a duplicate of table #1.
- For record #4, I modified the time. That is, I changed Joe's time from "33.1424" to "34.1111"
- I am using a join on Time.
- Given that Joe's time was changed in table #2, the fourth record is not displayed (as expected).
Here's what I need some help with. Modify the query so that the fourth record is *still shown* AS LONG as it within + / - 7.5 seconds. So, as long as the time value for Joe's (in table #2) is between 25.6424 and 40.6424, the query should pick it up. Alternatively, if Joe's time was, e.g., <= 25.6423 or >= 40.6425, the query should NOT pick up the fourth record.
Does anyone know how to modify the query to achieve this?