Hello again everyone,
I've been given a task to recreate an excel document using Alpha 5. I'm running into a few land mines so I thought I'd ask you guys how you would proceed, below is a list of my successes and failures on this portion of the project.
1. Because Alpha doesn't support this latest version of Excel, I've had to save the work book to a 97-2003 version. This worked when creating a new database from scratch, however, when I tried to import data from the same sheet, it gave me the warning that it needs to be a previous Excel version.
2. Saving the worksheet to a previous version makes it lose some of the functionality.
So at first I created a table with each of the fields in it and started to see if I could use calculated fields to work out the dates. One of the problems with this approach was the ASAP fields and TBD fields that don't really have values.
Next I tried creating some calculated fields that would only run when there was a date in that field.
Thanks for the help, I'm attaching the Excel spreadsheet, what I'm looking for as usual is just some suggestions on how you experienced Alpha guys would structure things and get past the calculation problems. As always if there is a help topic that you can point me at thats my preferred way of learning.
Respectfully,
Newander
I've been given a task to recreate an excel document using Alpha 5. I'm running into a few land mines so I thought I'd ask you guys how you would proceed, below is a list of my successes and failures on this portion of the project.
1. Because Alpha doesn't support this latest version of Excel, I've had to save the work book to a 97-2003 version. This worked when creating a new database from scratch, however, when I tried to import data from the same sheet, it gave me the warning that it needs to be a previous Excel version.
2. Saving the worksheet to a previous version makes it lose some of the functionality.
So at first I created a table with each of the fields in it and started to see if I could use calculated fields to work out the dates. One of the problems with this approach was the ASAP fields and TBD fields that don't really have values.
Next I tried creating some calculated fields that would only run when there was a date in that field.
Thanks for the help, I'm attaching the Excel spreadsheet, what I'm looking for as usual is just some suggestions on how you experienced Alpha guys would structure things and get past the calculation problems. As always if there is a help topic that you can point me at thats my preferred way of learning.
Respectfully,
Newander
Comment