NEED HELP WITH DATE/TIME FUNCTION

Question

I have made a query called Daily Dispatch Log Query and I am trying to get the query to ONLY show me calls for today's date.

My date is in 2017-04-26 15:28:00 format but when I try putting date() in the criteria field it does not return today's calls but shows that there are no calls ( even though it should show 4 of them.)  This MsAccess db is in test mode till I get all these bugs figured out and I am hoping this is the last bug so I  only have 4 calls.

I have the date this way because this is a computer aided dispatch program and the officers get their case number for calls as 201704261528   which is year month day hour etc.....

Now when I go into the query with no criteria it pulls up all the calls and then I can filter the calls to show Today, which is fine but I am trying to produce a report  based upon the today query so that we can have a hard copy of all the calls for the day that the officers responded to.  It would be nice ( and I know its possible) to do the query based on today and be able to make a report in access that pulls the "today" data and then I can print it out.

Need help !

borderchildren

Answer 1

Hi,

Try using a greater than or equal to criteria. For example:

>=Date()

Hope it helps...

Answer 2

.theDBguy  That my friend worked like a charm !!!  I have been racking my brain all day trying to figure this out and am completely googled out...  Thank you so much !

You would not happen to know how to automatically time/date stamp info being put into a text box would you?

I have a dispatch program that when you hit F-4 it would put a date/time stamp in the Narrative field as you added data such as drivers license info, person info and details of call, then you could have a time progression of events pertaining to that call.  I have not tackled this one yet.  I know that the dispatchers like the option and want to see it this CAD -computer aided dispatch program that I am attempting to write in MSAccess.  Any suggestions would be great !

Thanks again !

borderchildren

Answer 3

Hi,

Glad to hear you got it to work. In Access, the keyboard shortcut to enter the current time is Ctrl + : (colon). For date is Ctrl + ; (semicolon). Hope it's what you meant.

Cheers!

Answer 4

Thanks for your quick response !

The Crt +; worked and puts the date in the field but the other one creates a

new call for some reason instead of time stamping . I cannot get it to time stamp.

Is there a way to program a function key to do the trick for the time? or do you

have another suggestion?

Your help is greatly appreciated

borderchildren

Answer 5

Hi,

Yes, there is. Look up "Autokeys" It allows you to assign a keyboard shortcut to do almost anything you want.

Good luck!

Answer 6

okay I got it figured out... You were right but you have to hit the shift key 1st then the Ctr key then the semicolon.

Your the best ! 

thanks for making my job easier.

borderchildren

Answer 7

Hi,

Glad to hear you figured it out. Good luck with your project.