querry problem

[mezzanine1974]

I have a table which fields are: PERSON, DATE, MONEY
PERSON: Name and Surname of someone
DATE: Date
MONEY: Amount of money that person spend at that date

I assume that a specific PERSON can spend money as much as he wants
and in which day he needs.
I can not make such querry. I want to create a table which shows all
the PERSON and quantity of MONEY for the last day he spends.

if table is like that
PERSON_001----12DEC06----150$
PERSON_001----15DEC06----178$

Query should be
PERSON_001----15DEC06----178$//////////// because 15DEC06 is the last
day for PERSON_001

is it clear ?

 

[Michel Walsh]

There are 4 methods presented in
http://www.mvps.org/access/queries/qry0016.htm (about finding who is the
latest borrower of each book, in a library, problem quite similar to yours).


Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

wrong reference, try, instead,
http://www.mvps.org/access/queries/qry0020.htm


Vanderghast, Access MVP

 

[mezzanine1974]

Waww!! Devil is in detail.
Thank you so much. There are many things to learn in this fascinating
program.