Wrong sorting order in a form from an Access Project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002 and for about a week I am trying to migrate to SQL Server, but I still want to use the Access interface that I created....But I've got one big problem: when i have a field that has 2 rows as a source (the ID which is hidden and which is being used for relations and the name which is the displayed text) and i am trying to sort after that field...the result is shown sorted after the ID (the hidden part). How can I fix this and see the result sorted after the displayed text??
 
If I understand you correctly, you just need to use a query for the form's
source, as
SELECT AccountID, AccountCN
FROM AccountingStuff
ORDER BY AccountCN

HTH
Damon

Adrian said:
I am using Access 2002 and for about a week I am trying to migrate to SQL
Click to expand...
Server, but I still want to use the Access interface that I created....But
I've got one big problem: when i have a field that has 2 rows as a source
(the ID which is hidden and which is being used for relations and the name
which is the displayed text) and i am trying to sort after that field...the
result is shown sorted after the ID (the hidden part). How can I fix this
and see the result sorted after the displayed text??
 
it is not about the form's source.....it's about sorting data in a form after a column that has data selected just as you described. Only that when i sort it...the result is shown sort after the id, not after the visible data
 
Back
Top