Sort by Date Range

[sweetpea58]

Hi Everyone,

I haven't use DB in years so i'm a bit rusty. I have a large database and I wanted to have a report that is sorted by recently updated in 2 weeks, so i would give a range for the date, and the report would be filtered for that range. I build the report on a query and in that query I have a date field and a criteria:

Between [Start Date] And [End Date]

then I have a form with a command button to open the report.

So far, nothing works, Can someone help me please

 

[Smart]

In your report use sorting and grouping and sort on your date field desc

 

[sweetpea58]

Thanks smart, that helped a lot.

sweetpea

 

[Smart]

Glad I could help Sweetpea58