Thanks Hal, I'll try that.
--- In [email protected], [EMAIL PROTECTED] wrote: > Saiful, > You will need two queries. The first query is over the payments table > using the grouping function(the summation symbol), group on receiptid and > total payment amount. The second query add the table for applied amount and > the query for payment amount. Join the table to the query on receiptid and > then you can show the total of paid amount against one line of applied > amount. > Good Luck > Hal > > Hal McGee > Engineering Data Manager > Group Engineering - Process and Compliance > Seating Products Group > B/E Aerospace > Winston-Salem, NC > > > > "Saiful" > <[EMAIL PROTECTED] > l.com> To > Sent by: [email protected] > AccessDevelopers@ cc > yahoogroups.com > Subject > [AccessDevelopers] Re: Please help > 09/22/2005 03:57 me > AM > > > Please respond to > AccessDevelopers@ > yahoogroups.com > > > > > > > Thanks Cathy for the advice. > > But I really need to show both the PaymentAmt and AppliedAmt. > > The reason I need this is due to the customer might gave me 3 cheques > in a month, and I want a report that shows total of the 3 cheques and > to which invoice it has been applied to (so I don't have to use > calculator). > > --- In [email protected], "Cathy Jupp" > <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > Please zip all files prior to uploading to Files section. > > > YAHOO! GROUPS LINKS > > Visit your group "AccessDevelopers" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
