PREVIOUS RECORD VALUE "laveshhp via AccessMonster.com" <u26306[ at ]uwe> 08.09.2006 18:13:26 HELLO PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD) E.G DATE FIELD A FIELD B TOTAL (FIELD A + FIELD B) 9/1/2006 100.00 100.00 200.00 NOW I NEED IN QUERY LIKE THIS DATE OPBALA NCE FIELDA FIELDB TOTAL 9/2/06 200.00 50.00 50.00 300.00 9/3/06 300.00 100.00 100.00 500.00 9/4/06 500.00 THANKS LAVESH -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1

Re: PREVIOUS RECORD VALUE "ManningFan" <manningfan[ at ]gmail.com> 08.09.2006 18:49:29 This is why sites like www.rentacoder.com exist. Since you won't have records for all 7 days/week, the only way you're going to get that to work will be to use an array. laveshhp via AccessMonster.com wrote: [Quoted Text] > HELLO > PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM > I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD > FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD) > E.G > DATE FIELD A FIELD B TOTAL (FIELD A + FIELD B) > 9/1/2006 100.00 100.00 200.00 > > NOW I NEED IN QUERY LIKE THIS > > DATE OPBALA NCE FIELDA FIELDB TOTAL > 9/2/06 200.00 50.00 50.00 300.00 > 9/3/06 300.00 100.00 100.00 500.00 > 9/4/06 500.00 > > THANKS > LAVESH > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1

Re: PREVIOUS RECORD VALUE pietlinden[ at ]hotmail.com 09.09.2006 04:11:56 or he could go the easy way and automate Excel... or would that be too easy?

Re: PREVIOUS RECORD VALUE Khoa 09.09.2006 11:35:02 The other link: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q210/5/04.asp&NoWebContent=1 "pietlinden[ at ]hotmail.com" wrote: [Quoted Text] > or he could go the easy way and automate Excel... or would that be too > easy? > >