File Export "sort" issues

[jgelpi16]

Datasheet view in the Query. SQL below:

SELECT AAtblBankExport.Indicator, AAtblBankExport.EntityID, AAtblBankExport.FullName, AAtblBankExport.GarnDate, AAtblBankExport.GarnAmt, AAtblBankExport.Garnish, AAtblBankExport.MatchIndicator, AAtblBankExport.BalanceOnMatch, AAtblBankExport.Release, AAtblBankExport.ReleaseDate, AAtblBankExport.AmtRemitted, AAtblBankExport.DateRemitted, AAtblBankExport.GarnIndicator, AAtblBankExport.FI
FROM AAtblBankExport
ORDER BY AAtblBankExport.EntityID, AAtblBankExport.FI;

[RuralGuy]

That sure does not make sense to me. Any chance you could post a sample of your db to play with?

[jgelpi16]

Unfortunately I cannot. Should this work in most cases though?

[RuralGuy]

The simple answer is yes. Have you rebooted your machine recently? Have you imported your table into a fresh db and created a new query to see if the problem follows?

[jgelpi16]

I have not. However, all of this resides on a network drive and I am accessing it through Citrix so every time is essentially a "fresh" start as we have eight different serves. It only happens some times. Hopefully it won't continue. Thanks for your help.

[RuralGuy]

Is everyone using their *own* copy of the FrontEnd even though you are using a Terminal Server? They should be you know.

[jgelpi16]

Well currently this database is still in development phase. There will be a front end and back end once completed. Citrix will not be used in the final product because all users will be in the same building as the server/network drives. However, due to my proximity to the server location (roughly 100 miles) I must use Citrix.

[RuralGuy]

So right now it is a system under development and only used by a single person, right?

[jgelpi16]

That is correct.

[RuralGuy]

Another check here! This is an *unsplit* system with tables in Access and not SQL Server, right?