Sorting Problem

[jriano]

I have this report, it is suposed to sort using three different fields,
but it actually sorts using only the first field, and ignores the other two. Can someone tell me why? thank you

select
tblPlanInfo.lngPSINumb,
tblPlanInfo.chrPlanLtr,
tblPlanInfo.chrPlanName,
tblPlanAccounts.lngPSINumb,
tblPlanAccounts.chrPlanLtr,
tblPlanAccounts.chrInvFirmCode,
tblPlanAccounts.chrZipPSINumb,
tblPlanAccounts.chrInvFirmType,
tblPlanAccounts.chrInvFirmFBOName,
tblPlanAccounts.chrInvFirmAcctNumb,
tblPlanAccounts.blnPSIcopied,
tblPlanInvestmentFirms.chrInvFirmCode,
tblPlanInvestmentFirms.chrZipPSINumb,
tblPlanInvestmentFirms.chrFirmName

from
(tblPlanInfo inner join tblPlanAccounts
on tblPlanInfo.lngPSINumb
= tblPlanAccounts.lngPSINumb and
tblPlanInfo.chrPlanLtr
= tblPlanAccounts.chrPlanLtr)
left join
tblPlanInvestmentFirms
on tblPlanAccounts.chrInvFirmCode
= tblPlanInvestmentFirms.chrInvFirmCode and
tblPlanAccounts.chrZipPSINumb
= tblPlanInvestmentFirms.chrZipPSINumb

where
Forms.frmRepListPlanInvAcct.optAll=True

order by
tblPlanInfo.chrPlanName asc,
tblPlanInvestmentFirms.chrFirmName asc,
tblPlanAccounts.chrInvFirmFBOName asc

 

[WayneRyan]

j,

On the surface, it looks good.

Are you sure that the Report is not using the Sorting/Grouping
to alter the order?

Wayne

 

[jriano]

yeap, i am sure

 

[WayneRyan]

j,

Can you post your db?
Compact/Repair
ZIP
Attach

Wayne

 

[jriano]

sorry Waine, I cant, it has very sensitive data

 

[jriano]

wayne

 

[jriano]

I deleted the order by, and did it using the sorting window. I did it. Thank you.
Now I have another question. So you can not use order by? does it have to do with the fact that I am using headers? I tried first to delete the data in the sorting window, and then when i tried to run the report, it told me I needed to have a sorting field for the header or footer