Help with queries (Last payment date and payment amount)

[myemail.an]

Hi all,

I am a novice to Access, and was wondering if I could get some help on
a problem I can't solve.

I have a database with customer payments, structured like this:
customer code
type of payment
date of payment
payment amount

For each customer, filtering for one specific type of payment only, I
need to know what the last payment date was, and how much he paid on
that date. If there was more than one payment on that same day, I need
the sum.

I managed to build a query which yields the last payment date, and one
which sums payments by date, but how do I combine the two?

Thanks a lot for your help, and sorry if the question is too banal!

[Tom van Stiphout]

On Wed, 12 Sep 2007 04:06:18 -0700, "my********@googlemail.com"
<my********@googlemail.comwrote:

This is a good question. I solve it by creating two queries. The first
one finds the last date, then I inner join that query with the table
itself, typically joining on several fields (e.g. customercode,
paymentdate) to pick up the other fields (e.g. paymentamount) in the
row.

-Tom.

>Hi all,

I am a novice to Access, and was wondering if I could get some help on
a problem I can't solve.

I have a database with customer payments, structured like this:
customer code
type of payment
date of payment
payment amount

For each customer, filtering for one specific type of payment only, I
need to know what the last payment date was, and how much he paid on
that date. If there was more than one payment on that same day, I need
the sum.

I managed to build a query which yields the last payment date, and one
which sums payments by date, but how do I combine the two?

Thanks a lot for your help, and sorry if the question is too banal!