chavez@cookie.dec.com (Dale - 522-2336/3905) (05/10/88)
Is there a way to generate a numbered list from the Appleworks Database output? I know the records are numbered as they are created, but I'd like to have a numbered list created. Dale
jetzer@studsys.mu.edu (jetzer) (05/11/88)
In article <8805101521.AA14782@decwrl.dec.com>, chavez@cookie.dec.com (Dale - 522-2336/3905) writes: > Is there a way to generate a numbered list from the Appleworks > Database output? I know the records are numbered as they are created, > but I'd like to have a numbered list created. You really can't have each record numbered from within the AppleWorks database. (You can count the total number of records by creating a dummy category and putting a '1' in each field [do this automatically by setting the oa-v value] and then totalling the column). Short of manually entering the numbers, there are two alternatives that I can think of. 1. Print you DB file as a DIF file, and then read it into the SS. From there, immediately set your oa-v recalculation value to manual. Then oa-i(nsert) another column where you want the numbers to appear. Put a '1' in the first record. Then, in the next record, enter the formula +<up arrow>+1 and copy this formula into all the other cells. Then once - and only once - hit oa-k to calculate. Then print this back out as a DIF file, and read it back into your data base. (It ain't pretty, is it?). 2. If you have UltraMacro by the Beagle Bros, you can write a macor that will number the categories. Something along the lines of n:<adb><a = 1: begin: print a><rtn: a = a + 1: rpt>! should do it (this assumes that you go down when you press the return). Be quick on the escape key, because this will continue to run until you stop it. (Also note that I haven't actually tried this macro, but it should work.) This last method would be the preferred method, but you do have to go out and buy UltraMacro. I think everyone should do it because it's a great package, but hey ... -- Mike Jetzer "Hack first, ask questions later." Leaving for summer vacation at 10:01 am May 12. Keep this in mind for any responses you may feel necessary.
GZT.EWW@OZ.AI.MIT.EDU (Wes Williams) (05/19/88)
Sounds more like a job for DbaseIII+. If a numbered list is required from Appleworks, insert in within a field. But remember thet it is a locked feature and will not sort as an independant within the dbase (apwx). \|/es -------