Access Database Query Design

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.

Kemahiran: Microsoft Access, Visual Basic

Lihat lebih lanjut: n query, hour design, design access database, be smith, query table, pink design, access microsoft, database design record, access query table, contact access, database example, selected records, database table design, access table query, microsoft access query design, asap database, need access database design, query query, access query design, database entry visual basic, database design microsoft access, Query design, database design visual basic, number name, access 2012

Tentang Majikan:
( 10 ulasan ) Los Angeles, United States

ID Projek: #1567000

Dianugerahkan kepada:


Hi, it's easy. Will send to you in minutes.

$30 USD dalam 0 hari
(15 Ulasan)

2 pekerja bebas membida secara purata $115 untuk pekerjaan ini


I am an experienced developer and I can make this project done.

$200 USD dalam sehari
(3 Ulasan)