Sort oldest to newest on form

[Desstro]

I have a form that is based off of a query. They both contain field: start date and field: end date.



The query is filtered to sort oldest to newest however the form does not show as oldest to newest. I tried tinkering around with the form properties but have had no luck.

I also went as far as to set oldest to newest on the table that the query is based off of...still no luck.

Is there a way I can make the form, (which by the way will be on lock down for the end user) return the data from the query as sorted from oldest to newest?

OOps...just realized I didn't set this as a (?) in the forum...srry.

[RuralGuy]

Does your query have an OrderBy clause? If so, would you post it please so we can see it?

[Desstro]

It does not have an OrderBy clause. The only criteria in the query is under

"shift" =1 or =3
"StartDate" <=Date()
"EndDate" >=Date()

I sorted the query by right clicking the StartDate header on the datasheet view and selecting oldest to newest, save.

How do I set an OrderBy clause?

[RuralGuy]

You need to also select the Sort criteria in the column you wish in the design view of the query. The filters you selected do not sort but just constrain the records returned.

[Desstro]

I think I figured it out. In the queries properties I set sort Ascending. Seems to work.

[Desstro]

LOL...thanks RuralGuy. Will mark as solved.

[RuralGuy]

Glad we could help.