Thread: Word / Database
View Single Post
  #4  
Old 2011-04-07, 08:00 PM
xjsb125 xjsb125 is offline
 
Join Date: Oct 2006
Location: Bristol, VA
Re: Word / Database

Remove Word and download Open Office. From there your entries need to have a uniform structure to them. Your current list is not uniform in the way the dates are typed, venues, and some even have the source after them.

Example:
John McLaughlin - 2010-11-18 Potawatami Casino's, Milwaukee
John McLaughlin - Master Class- New Morning-95_12_13
John McLaughlin & One Truth Band - 1978 09 07 Berlin FM

Uniform:
John McLaughlin - 2010-11-18 - Potawatami Casino's - Milwaukee, WI
John McLaughlin - 1995-12-13 - Master Class - Unknown
John McLaughlin & One Truth Band - 1978-09-07 - FM Broadcast - Berlin, Germany

Once everything is uniform, you should be able to import it into a spreadsheet such as Excel or Calc in Open Office. Once it's in the spreadsheet, if you name the columns, you can sort the whole sheet by artist, date, venue, whatever you like.
Reply With Quote Reply with Nested Quotes