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!
 
Top