Change Query

[Bob]

--


My Query has 2 fields Item;Cost; how can I sort descending Cost first, then
descending Item next, tried putting the Cost on left in my query but then my
Combo Drop down list shows Cost first instead of Item...Thanks for any
help..Bob

 

[Bob]

Oops I change the Row source to:
SELECT QryDailyRate.ServiceInfo, QryDailyRate.Rate FROM QryDailyRate;
Does this look ok?......Thanks Bob

 

[Douglas J. Steele]

It's missing the ORDER BY clause, but otherwise it looks okay.

SELECT ServiceInfo, Rate FROM QryDailyRate ORDER BY Rate DESC, ServiceInfo

 

[Bob]

Thanks Douglas I will change it.....Bob

It's missing the ORDER BY clause, but otherwise it looks okay.

SELECT ServiceInfo, Rate FROM QryDailyRate ORDER BY Rate DESC, ServiceInfo

 

[Bob]

When I changed to your script, the Combo Box would not select the record.
So I Did a A-Z sort on Rate in my table and uesed this script
SELECT ServiceID, ServiceInfo, Rate, ynMonthly FROM tblServiceInfo ORDER BY
ServiceInfo;
Works Ok but it does not sort a-z on Service if they are the same price
Thanks Bob

 

[Douglas J. Steele]

What do you mean by "the Combo Box would not select the record"?