Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Wink Unanswered: novice in need of help with expression

    Okay I have a table that has two fields that I need to compare and find the difference.

    The first is the date the work was due = Date Due
    the second is the date the work was complete = Complete Date

    I need at third field to be days late in numerical form to show the number of days the work is late - Days Late

    I know my expression should be something like

    DateDiff("d",[Issue Date],[Complete Date])

    but where do I put this for it to work?


    When I attempt to run it as a query the results I gat are blank

  2. #2
    Join Date
    Feb 2004
    Location
    Houston TX
    Posts
    23
    you do this in qurey after adding the fields that you need just add this line in the last one (syntax only)

    Days_LateateDiff("d",[Issue Date],[Complete Date])

    this will give you the late days number.

    if you want to add it to the table (not recommended, as you can always calculate this on the fly, saving space on the disk), use the same query as an update qurey and update the empty field "Days_Late" in there.

    Hope it helps
    Believe Everybody Trust Nobody

  3. #3
    Join Date
    Feb 2004
    Location
    Houston TX
    Posts
    23

    Smile

    it didnt showed up as expected just remove the spaces between the colon and the D next to it when entering the actual info
    you do this in qurey after adding the fields that you need just add this line in the last one (syntax only)

    Days_Late: DateDiff("d",[Issue Date],[Complete Date])

    this will give you the late days number.

    if you want to add it to the table (not recommended, as you can always calculate this on the fly, saving space on the disk), use the same query as an update qurey and update the empty field "Days_Late" in there.

    Hope it helps
    Believe Everybody Trust Nobody

Posting Permissions

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