querry problem

M

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 ?
 
M

mezzanine1974

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