Select exact record on date and time

[nigel]

Please help. A hire database with thousands of hire records. Each eqpt hire has a date and time out and a date and time in. If i need to pinpoint exactly where the equipment was at a particular time and day, I'd like to set a form with the criteria Eqpt ID number, date and time, and then the search button wood 'Look into'all my records and select the exact one.
I am getting round it by entering just the eqpt ID and opening a form with ALL the records associated with the equipment, then scrolling to the correct one. This is not too time consuming but getting worse as the database grows.

Any help will be appreciated

Nigel Nicholson

.

 

[AlaskanDad]

You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh button on the form to have your data reflect the date/time you are looking for.

 

[AlaskanDad]

You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh button on the form to have your data reflect the date/time you are looking for.

 

[AlaskanDad]

You need to set up your form recordset as a query. First, identify all records where the Eqpt ID = whatever you type in a text box in the form. Next, the date/time out is < the time you type in the form AND > the date/time in. You can build this in the design view of a query. Have a Refresh button on the form to have your data reflect the date/time you are looking for.