By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,079 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,079 IT Pros & Developers. It's quick & easy.

Help with queries (Last payment date and payment amount)

P: n/a
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!

Sep 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!
Sep 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.