Order By

  • Thread starter Thread starter Irene
  • Start date Start date
I

Irene

I have a continuous form. in the form, i want the it order by Part code then
by deliver date. i try to set one, it run ok. but i put 2, then it doesn't
work. how can i set the order by in the form? thanks!
 
I have a continuous form. in the form, i want the it order by Part code then
by deliver date. i try to set one, it run ok. but i put 2, then it doesn't
work. how can i set the order by in the form? thanks!
Click to expand...

Create a query that displays all the fields you wish to have in the
form.
Access sorts multiple columns in left to right order.
Move (drag) the 2 columns so that the PartCode column is to the left
of the DeliverDate column.
In the sort row of the 2 columns, write Ascending.

If you then look at the query SQL it will look something like this:

Select TableName.* from TableName Order By PartCode, DeliverDate;

Use this query as the record source for your form.
 
thanks a lot!

fredg said:
Create a query that displays all the fields you wish to have in the
form.
Access sorts multiple columns in left to right order.
Move (drag) the 2 columns so that the PartCode column is to the left
of the DeliverDate column.
In the sort row of the 2 columns, write Ascending.

If you then look at the query SQL it will look something like this:

Select TableName.* from TableName Order By PartCode, DeliverDate;

Use this query as the record source for your form.
Click to expand...
 
Back
Top