I have a large table with several fields: including: DATE, TIME, TELEPHONE NUMBER, NAME.
I need a query created so that if I select a name (for example "John Smith"), then Access will return All records with the name "John Smith" AND any records 1 hour before that entry, AND 1 hour after that entry.
(so in the example, the Record highlighted in Pink would be returned, as well as the records above it and the records below it, since they are all within 1 hour before/after the selected record).
Need this query done asap. If doable - please contact me.