M/SOFT Works

  cgen 13:45 26 Jul 2005
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 2005

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

  mjf85 17:11 26 Jul 2005

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 2005

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?