Help on sorting

[richardplr]

Hi

I have a query and I have 2 need 2 sorting within the query.

1st query is Product Name (I need this to be Secondary sort)
2nd query is Date (This to be primary sort).

Can I do group, if yes. How to do (Sorry, I have forgotten how to do)

Tks


Regards,

 

[Liv Manto]

1st query is Product Name (I need this to be Secondary sort)
2nd query is Date (This to be primary sort).



If you are not kidding:

drag the product name first, then the date. ascending both.

The primary sort field should go first at the query grid.

 

[richardplr]

1st query is Product Name (I need this to be Secondary sort)
2nd query is Date (This to be primary sort).



If you are not kidding:

drag the product name first, then the date. ascending both.

The primary sort field should go first at the query grid.

Hi

I am not kidding (of course).

I understand but my format of the query is Product Name first then Date behind. I know that the primary sort field should come first.

Anyone thank you for your help.

Regards,

 

[richardplr]

It really doesn't matter what order the fields occur in a query. You shouldn't be showing queries to the user anyway.

To get the fields to sort the way you want and also the columns ordered the way you want, you can add the problem field(s) to the QBE grid a second time. So, if you want to sort by date first, drag the date field to the left column of the grid. Choose ascending or descending. Uncheck the show box. This tells Access to not include the column a second time in the output but just to use this duplicate to control sort order.

Ya, I understand already.

You are good. I got what you mean.

Bye