Date in continuous form

[pwalt08]

Hello,

I have a table, and form that are going to be used as a call log. The form will be continuous for a month and then we will run a query to delete old calls.

The table has a hidden field for date. I would like this field auto populated which I am able to do. The problem I am running into is 3rd shift 11p -7a. I would the like the field to auto populate with the previous date until 7am then start to use the new date.

This is my first database and I am learning as I go. Any help is greatly appreciated!!

 

[guerillaunit]

In design view, sort both your "todays date" column and "timerequested" column. Because you want to take into account the overnight shift, make sure the "todays date" column is to the left of the "timerequested" column (Access sorts from left to right in design view).

 

[pwalt08]

If the date field asks [what date?] and the user puts in 2/4/12. How do I get the query to display records from 7am on 2/4/12 to 6:59am on 2/5/12

 

[guerillaunit]

Set "[what date?]" as the criteria for the column "todays date"

 

[pwalt08]

Thanks for all your help!

This is what I did.

First line of criteria is [What Date?] AND Between #7:00:00 AM# and #11:59:59 PM#

Second Line of criteria is [What Date?]+1 AND Between #12:00:00 AM# and #6:59:59 AM#