Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

quick sort

Status
Not open for further replies.

mbaddar

Programmer
May 10, 2001
120
US
Hi,

Does anyone know how to do a quick sort in a table?
I want to go into a table's data view and delete all records that fall within a certain date range (simply
by highlighting the starting and ending records and clicking delete).
However, before I can delete the records, I need
to sort them because I only want to delete records
before 2000. Short of writing
a query is there any tool,option that allows you to
do a quick and easy sort on a table's data?

Thanks,
MBaddar
 
Hi

If you go to Records then Sort on the ToolBar (in database design view), make sure you are in the field that you want to sort - you can sort your table and then find the rows that have the records in that you want to delete and then highlight them, make sure that you select from the side so the whole row is highlited and then hit the delete key, you will need to confirm if you still want to delete them.

tee
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top