Results 1 to 2 of 2
  1. #1
    whadave is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2017
    Location
    Pulaski, TN
    Posts
    1

    Not getting any data whan I try to query on date and time


    I have a basic database in Access 2013 where I am trying to track picks based on the scans from our warehouse system.

    When I import the data from Excel I end up with date and time fields. I would like to take the first date column and use it to filter and deliver (hope I am saying all of this correctly) only one day at a time.

    I looked up date and time criteria and have tried a number of ways but no mater what I put into the criteria field, I get nothing as a result.

    I have zipped the file and attached it so you can see where I am so far.

    Thanks in advance for all of your help.
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Not sure what you're asking, or what you've tried. This:

    Expr1: [0801].EDITDATE

    won't work because there is no such field in that table. If you're trying to filter a date/time field on date alone, there are numerous ways. I'd use a form, but to give you an idea this works:

    Between #8/1/2017# And DateAdd("n",1339,#8/1/2017#)

    There are solutions that use a formula to convert the date/time field to date only, but I feel they're less efficient.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 04-19-2016, 03:58 PM
  2. Replies: 2
    Last Post: 01-19-2016, 06:05 AM
  3. Replies: 11
    Last Post: 07-20-2014, 06:22 PM
  4. Replies: 1
    Last Post: 03-13-2014, 07:23 PM
  5. Replies: 3
    Last Post: 03-11-2014, 07:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums