locked
NEED HELP WITH DATE/TIME FUNCTION RRS feed

  • 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