Problem sorting [DATE] field in a subform

[mkdrep]

I have a subform which tracks all the notes our personnel have entered in a specific project (which is the main form).

The issue is that I want the most current note to show in the subform when the project is "opened up". The underlying query for the subform has the [DATE] field sorted on "Descending".

Any suggestions as to how I could accomplish this? Thanks

 

[EternalMyrtle]

If the data type is date/time, that should work.

Are there any other fields in the query with a sort on them? If so, make sure the date field comes first. It is easy to overlook that.

Or if you checked that and it still isn't working you could try using an order by in your subform: http://office.microsoft.com/en-us/access-help/orderby-property-HA001232775.aspx

 

[mkdrep]

If the data type is date/time, that should work.

Are there any other fields in the query with a sort on them? If so, make sure the date field comes first. It is easy to overlook that.

Or if you checked that and it still isn't working you could try using an order by in your subform: http://office.microsoft.com/en-us/access-help/orderby-property-HA001232775.aspx

Finally got back to addressing this issue and your suggestion to look at the order by property did the trick! Thank you very much!