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

Newbie Member
28May2008,18:51   #1
vip79's Avatar
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