Sorting recordes in a table

[Bernie K]

I want to sort the records in a table by LastName FirstName, but I do not
want the record ID numbers to be include in the sort. Can this be done? If
so how?

Thanks,
Bernie K

 

[Jeff Boyce]

Bernie

Access tables store data (as a "bucket o' data") without any
(human-discernable) sort order.

A standard approach to getting a list of LastName, FirstName from a table is
to use a query and do the concatenation and sorting there.

Regards

Jeff Boyce
Microsoft Office/Access MVP