1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

DateVAlue function or how to sort a future dates record in a report

Discussion in 'MS Access' started by vip79, May 28, 2008.

  1. vip79

    vip79 New Member

    Joined:
    May 20, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    undefined

    To Whom it may concern:
    I am trying to sort a future date record in form of a report.
    I made a tabel name" Bill due" then i made a form name "Bill" in the form i placed a button in there i gave a link to a query "Bill due query" and with a criteria " DateAdd("d",7,Date())" but it only returns me the 7th day record in a report not all coming 7 days.

    Please help me with this query.

    Thank you
     

Share This Page