Query Most Recent Payment

[vsholl]

I have two tables.
1. tblProjID
2. tblPmtHistory

I need to query info from ProjID and from tblPmt History I
want only the most recent payment. The payment data can
be queried eith by payment date or payment number.

Please help.

Vicki

 

[Jeff Boyce]

Vicki

You don't mention if/how the two tables are related. If you need to find
the most recent payment, consider using a "Totals" query against the
Payments table, with the "Maximum" grouping selected on the field in
question.

If you have more than one way (date, number), you need more than one query.

Good luck

Jeff Boyce
<Access MVP>