Reordering entries in form -- sql server (alternate)

Neil Greenough
10/13/2004 1:06:21 PM

I have a form with a few entries running in it, 1-10. Now, what I would like
if possible, is for the entries to be reorganised so that they are listed
alphabetically. So, when I open the form, instead of getting entry number
one, I get the entry beginning with A.

I have resorted the columns in my table, however this ain't helped.

Simon Hayes
10/13/2004 3:39:39 PM

[quoted text, click to view]

Is this another Access question? :-)

In MSSQL, you could order the data with an ORDER BY when you retrieve it
from the database:

select col1, col2, col3
from table1
order by col2

I have no idea how you would do it in an Access form, though. You might want
to try in microsoft.public.access.forms.

Simon

sql server (alternate) : Reordering entries in form