Just a thought, but why not just total the applied amounts and don't total the Payment amounts at all? This would of course not work if not all of each payment is applied, but your example seems to suggest that it is. Cathy
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Saiful Sent: 22 September 2005 07:57 To: [email protected] Subject: [AccessDevelopers] Please help me hi all, I have to table that linked to one query. For example : Table1 Table2 ------ ------ ReceiptId ReceiptId PaymentAmt AppliedAmt ChqNo InvoiceId ------------------------ 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/
