order by setting itself

[byterbit]

2007, a report based on a query; after it runs(badly) I see the "order by" in properties/data has set itself to: "[contacts].[meter_type] DESC, [contacts].[Meter_Size] DESC"



This has *nothing* to do with the order by in the SQL statement in the query (see below) OR the sorting I set in "sorting and grouping" (which I set to reinforce the order set in the query.

I don't get it.



SELECT contacts.code, contacts.ZIP, contacts.Appointment_Date, contacts.METER, contacts.NEW_METER, contacts.PREFIX, contacts.TICKET, contacts.HOUSE, contacts.CP, contacts.STREET, contacts.ART, contacts.[PART SUP], contacts.CUSTOMER, contacts.PHONE, contacts.meter_type, contacts.[INSP STAT], contacts.[AIP GRP CODE], contacts.[SCHED SND], contacts.[PGM TYPE], contacts.[Appointment _Time], contacts.Status, contacts.notes, contacts.crew, contacts.aip_group, [street] & " " & [art] AS Expr1, contacts.Appointment_Time_order, contacts.Meter_Size
FROM contacts
WHERE (((contacts.code)=GetMyVariable()) AND ((contacts.Appointment_Date)=[forms]![daily_report]![text0]) AND ((contacts.Status)="Appointment Scheduled"))
ORDER BY contacts.Appointment_Time_order;

[RuralGuy]

FYI a Report does not use an OrderBy clause in a query. It always uses the OrderBy set in the Report "sorting and grouping" area. You may want to start by *importing* your db into a fresh new db and see if the issue follows: http://www.btabdevelopment.com/ts/impnew