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 --------------------~-->
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/
