Just to follow up, I looked at how my data was being imported (below). It's basically reverse chronological. LBP sorted everything perfect for the spreadsheet view. In the reports, it sorted the date correct just not the leg order.
Instead of re-entering all the info, I exported LBP to excel and the legs exported exatly as they appeared in the spreadsheet view. I then saved the file and imported it back into LBP replacing the existing data. All the data was there and running a report showed the same sequence as the spreadsheet. Saved the time re-entering the data and problem solved.
|