In a query, I have the following fields:
OrderNo.
CustomerName
Date
Price

I tried to sort the data by CustomerNamer whose OrderNo. has been sorted also. In the query, if I sort the Customer and OrderNo, but the OrderNo hasn't been sorted. Can anyone know the reason and how to fix it? Appreciated for any help!

flyfish

__________________
flyfish

Order number is numeric or text field? (I think it should be numeric).

can u paste the SQL query, which u are using?


Om Prakash

The type of orderID is text.
I created the query in the design view, I think I can view the query in SQL view. Here is the SQL view of the query:
SELECT tbl_order_summary.EmpoyeeID, tbl_order_summary.CompanyName, tbl_order_summary.OrderID, tbl_order_summary.OrderedDate
FROM tbl_order_summary
ORDER BY tbl_order_summary.CompanyName;

I am wonerding how can I sort the orderID also?

Thank you for your reply!

flyfish

If you want to sort the numeric OrderID (and if it is all numeric, then you can use convert(int,OrderID) in order by clause. but this will give u error when there is text content).


Om Prakash

I still do not know why I can only sort one field in the query, even if I tried to sorted the data by CustomerName and Date. After I run the query, only the leftmost column has been sorted. Why?

Appreciated for any replies!

flyfish

Hi

Set both fields sorting ascending. Here is the SQL syntax

SELECT tbl_order_summary.EmpoyeeID, tbl_order_summary.CompanyName, tbl_order_summary.OrderID, tbl_order_summary.OrderedDate
FROM tbl_order_summary
ORDER BY tbl_order_summary.CompanyName, tbl_order_summary.OrderedDate;

-vemaju