Hi, I want to refer a particular column value of a previous record to another column of new record in the same table.
for example if i have a simple stcoks table as follows Date Opening balance Input total expense netbal 01-10-05 0 10 10 4 6 02-10-05 6 15 21 7 14 05-10-05 14 5 19 2 17 08-10-05 17 3 20 8 12 ie., in this table the previous record's netbal (for ex: 01-10-05 netbal=6, the opening balance for 02-10-05 should be 6 and this has to be refered automatically) Can u help me solve this. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
