1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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