Answered by:
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
Wednesday, April 26, 2017 8:36 PM
Answers
-
Hi,
Try using a greater than or equal to criteria. For example:
>=Date()
Hope it helps...
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:00 PM
Wednesday, April 26, 2017 8:43 PM -
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!
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:35 PM
Wednesday, April 26, 2017 9:10 PM -
Hi,
Yes, there is. Look up "Autokeys" It allows you to assign a keyboard shortcut to do almost anything you want.
Good luck!
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:35 PM
Wednesday, April 26, 2017 9:30 PM
All replies
-
Hi,
Try using a greater than or equal to criteria. For example:
>=Date()
Hope it helps...
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:00 PM
Wednesday, April 26, 2017 8:43 PM -
.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
Wednesday, April 26, 2017 8:59 PM -
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!
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:35 PM
Wednesday, April 26, 2017 9:10 PM -
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
Wednesday, April 26, 2017 9:26 PM -
Hi,
Yes, there is. Look up "Autokeys" It allows you to assign a keyboard shortcut to do almost anything you want.
Good luck!
- Marked as answer by borderchildren Wednesday, April 26, 2017 9:35 PM
Wednesday, April 26, 2017 9:30 PM -
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
Wednesday, April 26, 2017 9:31 PM -
Hi,
Glad to hear you figured it out. Good luck with your project.
Wednesday, April 26, 2017 9:38 PM