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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice