Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I received a description of a problem (no example) from a former student today. Have a question maybe you can help me solve.

    Here is his original question:
    I need to propagate a list of cells that are 14 days
    from reaching the date in the cells. This is not working "(14
    day)<(DbDate)" this is Access 2003.

    I am guessing what he is trying to say here. I think in a query he needs a new column to contain a formula like:

    Getting Close: =IF([DueDate]=[OverDue]-14,[DueDate],""]) but how would he write this

    HELP! My mind is gone today...heck it's gone on most days, you've probably guessed that by now...but appreciate the help on this.

    He may also just need a filter...any help at all
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Create a field in the query that subtracts the appropriate fields. Set the criteria to 14.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, here is a better understanding of what he is looking for:

    Proj number Location Description Req comp date Act comp date remarks

    He wants to be able to query a list of incomplete jobs
    within 14 days of req comp date. The act comp date will have a null criteria
    to identify it to be incomplete as I understand it.

    Can you help me with the Access query formula that will help him get what he wants?

    Thank you.



    Quote Originally Posted by teachesms View Post
    I received a description of a problem (no example) from a former student today. Have a question maybe you can help me solve.

    Here is his original question:
    I need to propagate a list of cells that are 14 days
    from reaching the date in the cells. This is not working "(14
    day)<(DbDate)" this is Access 2003.

    I am guessing what he is trying to say here. I think in a query he needs a new column to contain a formula like:

    Getting Close: =IF([DueDate]=[OverDue]-14,[DueDate],""]) but how would he write this

    HELP! My mind is gone today...heck it's gone on most days, you've probably guessed that by now...but appreciate the help on this.

    He may also just need a filter...any help at all
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Create a column with the formula of DaysOut:[rew comp date] - Date(). Set the criteria to <=14.
    Set the Act Comp field's criteria to "Is Null" (without the quotes)

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by mbarron View Post
    Create a column with the formula of DaysOut:[rew comp date] - Date(). Set the criteria to <=14.
    Set the Act Comp field's criteria to "Is Null" (without the quotes)

    Will let you know if this works for him when he emails me back. Thank you for helping. It is MCI's fault that he can't do this for himself, as MCI blocks anything that looks like a chat room where he works, so I am having to do the asking myself today (which I always told them I would). I still give Woody's all the KUDUs.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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