Order by property and date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort my records on a form by a date field called [Job_Due]
however when I set the order by property of the form to [Job_Due] it doesn't
seem to do anything. What could I be missing ?
 
Gazza said:
I am trying to sort my records on a form by a date field called [Job_Due]
however when I set the order by property of the form to [Job_Due] it doesn't
seem to do anything. What could I be missing ?
Click to expand...

Is the form based on a table or a query? If it's based on a query, you
could conflicting sorting in the underlying query.
 
Hi Gazza - check on your underlying data source for the form - presume it's a
query. Set the sort there. Works better that way. Like you I've tried to set
it on the Form Property with little luck, actually even when it is set on the
form and working properly the Property Order by often says something else.
Yours - Dika
 
The underlying data source is a query - which I have specified to sort
ascending by Job_Due. It is'nt sorting by this at all whether I remove the
order by property or not.

Kernow Girl said:
Hi Gazza - check on your underlying data source for the form - presume it's a
query. Set the sort there. Works better that way. Like you I've tried to set
it on the Form Property with little luck, actually even when it is set on the
form and working properly the Property Order by often says something else.
Yours - Dika

Gazza said:
I am trying to sort my records on a form by a date field called [Job_Due]
however when I set the order by property of the form to [Job_Due] it doesn't
seem to do anything. What could I be missing ?
Click to expand...
Click to expand...
 
OK, never mind, you were right. I recreated the form from the query and now
it is sorted correctly. Must have made a mistake last time I created it.

Thanks

Gazza said:
The underlying data source is a query - which I have specified to sort
ascending by Job_Due. It is'nt sorting by this at all whether I remove the
order by property or not.

Kernow Girl said:
Hi Gazza - check on your underlying data source for the form - presume it's a
query. Set the sort there. Works better that way. Like you I've tried to set
it on the Form Property with little luck, actually even when it is set on the
form and working properly the Property Order by often says something else.
Yours - Dika

Gazza said:
I am trying to sort my records on a form by a date field called [Job_Due]
however when I set the order by property of the form to [Job_Due] it doesn't
seem to do anything. What could I be missing ?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top