Results 1 to 2 of 2
  1. #1
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58

    Question Passthrough over a timestamp?

    I have a table with timestamp as one of the columns. I am having to use a passthrough query on this table to get a few other fields which are not available on the access front end. Now i am trying to filter those records based on a date range. But the passthrough wont let me give the date range! This is what i tried:

    Code:
     
    SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
    FROM DBA.case_intake
    WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN '06/01/2011 00:00:00 AM' AND '12/01/2011 00:00:00 AM';
    2nd try:

    Code:
     
    SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
    FROM DBA.case_intake
    WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN '06/01/2011' AND '12/01/2011';
    I also tried

    Code:
     
    SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
    FROM DBA.case_intake
    WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN #06/01/2011# AND #12/01/2011#;
    Nothing works! How can i get the query to read the date range??



    Your thoughts and time are appreciated.
    Kris

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    passthrough to where ? is really the question. rhetorically speaking.... date/time formats can differ by database. so you should really orient the question to the owner of the destination database where the query is running. that person can best help you with the format syntax that their database requires.

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

Similar Threads

  1. Cannot Make Table with Passthrough Query
    By chasemhi in forum Import/Export Data
    Replies: 0
    Last Post: 12-05-2011, 01:30 PM
  2. Add timestamp after text entry
    By JeffG3209 in forum Programming
    Replies: 4
    Last Post: 06-29-2011, 10:21 PM
  3. Replies: 2
    Last Post: 11-11-2008, 01:12 PM
  4. Replies: 0
    Last Post: 11-06-2008, 12:29 PM
  5. Access Timestamp...
    By HMel in forum Access
    Replies: 4
    Last Post: 08-19-2008, 01:30 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