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.
DateVAlue function or how to sort a future dates record in a report