my self avi developing application in vb6.0 and sql server 2000 which is running on lan. i have a table say ReceiptbookMaster having fields RBookNo,StartReceNo,EndRecNo.
RBookNo startreceno Endrecno
a5555 1 25
i.e. there is receiptbook of no a5555 and it has receipt from 1 to 25. now i entered each receipts entry in receipttable. i.e. it has Rbookno,receiptno,name,amount,Rdate. suppose there are records in receipttable like
Rbookno receiptno name amount rdate
a5555 1 avi 5000 1/1/05
a5555 4 xyz 100 2/1/05
a5555 7 pqr 250 5/5/05
now i want to find the balance no and missing no of receiptbookno a5555.
how to write query for this
now i want to
Enter your message below
Sign in or Join us (it's free).