M/SOFT Works

  cgen 13:45 26 Jul 05
Locked

i would like to create a database as below

LOC TYPE Artist Title
0001 LP Lennon, John Imagine
0002 LP Stewart, Rod Sailing

so that when the type artist and title fields are sorted alphabeticly the location number will stay where it is. therefore LOC to be constant

  mole44 17:08 26 Jul 05

where i work we use a spreadsheet try using the one on works

  mjf85 17:11 26 Jul 05

Use Ms Access or a similar program, spread sheets dont keep the records together, they treat each column seperatly so while they will be sorted alaphbetically the information will have no reliavnce to itself.

IF that makes sence

  bobbybowls 17:53 26 Jul 05

have loc type artist title in a1-b1 etc and 0001 lennon john etc in a2-b2 etc then select all cells apart from loc then data-sort in excel or tools-sort in ms works you should then have a choice of 3 sort options

This thread is now locked and can not be replied to.

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…