Display Records For A Certian Time Period

G

Glenn White

Please help! I have main form and subform that displays maintenance records. I am able to refresh the records in the subform if they are greater than the current time. However, I would like to display the records if they fall between a 48 hour period from the current time. I have a field called StartTime and EndTime which are both formatted as Medium Time

How create a query that will display this information. Do I use Time() or DateAdd? Any help will be greatly appreciated

Thank You!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up total time in a contious form 7
Populate main form from subform record 0
Subform only showing 1 record instead of all records 6
Filter on Subform Not Displaying as Expected 1
Show record numbers on subforms 1
Calculate time difference 3
Combo box that display records on subform 2
displaying records on subform 0

Top