Display oldest date in query on report

[FlyGuyTray]

I have a report that displays the number of unfinished items that need to be completed. On this report i want to display the date of the oldest unfinished item. There is a 'Date_Created' field in my query and thats the field that the information would come from.

Thanks in advance.

 

[DCrake]

What you need to do is to create a new fiedl in your table say DateTimeStamp and make it Date/Time type and in the default value put =Now()

This will store the exact date and time the record ws created in this field. You can then use this to sort on. However do you not have a date field already in your table that you can sort on. Noone can say that all new records are added sequentially in the order that the orders were generated.

 

[Brianwarnock]

Min will give the smallest value by Group therefore the earliest date.

Brian

 

[FlyGuyTray]

Thanks Guys!