Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Austin, TX
    Posts
    21

    Unanswered: Query For Records Older Than 32 Days, Access 2007

    I have a table (tblEnvDoc) that has two date fields: DateReceived and DateApproved. I want to run a query that will show those records that are greater than 32 days between DateReceived and DateApproved. If DateApproved Is Null, then I want to count 32 days from DateReceived. It seems like it should be simple but I'm not seeing it yet. Can anyone help. Thanks in advance.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    This should work:

    Code:
    SELECT * FROM tblEnvDoc WHERE Nz(DateApproved, Date()) > (DateReceived + 32)
    Sam

  3. #3
    Join Date
    Apr 2003
    Location
    Austin, TX
    Posts
    21
    Sincere thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •