I need to access the data from 1, 2, 3, 4 records previous to the current record. This is what I have come up with so far.

my $current=$rec{'$keyfield'}-1;
my %rec2 = &get_record('$current');

I am not very well versed in perl, but I think this should work... any suggestions?

Are you wanting to create a report to to perform calculations on the fields?

If so, I'm sure if you visit the FAQ noted below and look under the sections "Calculate" and "Viewing" you will find some ideas and possible solutions.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

LoisC,

Thank You. Your DBman Help FAQ is an awesome resource. I found a post that is pertinent to my dilemna (http://webmagic.hypermart.net/...us&nh=4&mh=1), however it does not seem to work for me. Maybe I am doing something wrong?

This is the code it recommends...



I would like to apply the value to a new hash called %rec2 by this;

%rec2=&get_record($next);

Any Help?

I'm afraid posting the url to the FAQ doesn't work as you have to be logged in to view the database. Also there is no reference to the record ID or original thread.

Perhaps you can locate this reference again and then locate the original thread (noted within the record) and then reference that directly. Sometimes the actual thread reference differs in the FAQ, so by providing the title, etc. a search can be done to locate the original thread here in the forum.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Sorry about that, Here is the entire thread. I don't see how you get to the original thread? I know this isn't what I need but the part where calculations are done on the %rec. It still isn't working for me... any comments anyone?