jabeer
12-29-2009, 11:38 AM
i am posting my newly constructed database, records deleted.
the problem is i cant calculate the "bottles At Customer" balance in my report.
in my understanding this should be simple as OPENING BALANCE(from Customer Tbl)+Delivered(MIS DSR Tbl)-OKMTReceived(MIS DSR Tbl).
can some one help me pls!
MSAccessRookie
12-29-2009, 12:00 PM
i am posting my newly constructed database, records deleted.
Looks like the attachment may have fallen off as you were posting your question on the message board. Can you try again?
jabeer
12-30-2009, 12:12 PM
okay i forgot to zip it, now its okay i think!
jabeer
12-31-2009, 12:32 PM
hey! can anyone plz help me?
boblarson
12-31-2009, 01:42 PM
hey! can anyone plz help me?
Sure, take a look now at the attached. I THINK I understood what you wanted.
jabeer
12-31-2009, 02:55 PM
thank you boblarson for your reply...
infact i want to calculate the last field(5=BtlAtCstmr)"|5=4+1-2|".
Field4=OpeningBtlInHand(withCstmr)shown in Customer Table
Field1 and 2=Delivered and Received Btl Qty, shown in MIS DSR Tbl
i am sorry i dont know how to explain my problem.
in fact i have a table with custoemer opening btl balance. second table with btl delivered and received qty in MIS DSR.
on report i want to calculate, IN EACH ROW, Opening+delivered-Received.
Thanks