Max date

[dhoover via AccessMonster.com]

I have a query that looks that this:


Customer1 Loan#1 Date Rate
Customer1 Loan#1 Date Rate
Customer1 Loan#2 Date Rate
Customer2 Loan#1 Date Rate
Customer3 Loan#1 Date Rate


I need to be able to pull the max date for each loan # for each customer, so
in the example above I would get two results for customer1 and one result for
customer2 and customer3.

I've tried using max date, but that's not woring like I need it to

 

[KARL DEWEY]

That will happen if you included the Rate and the rates are different. Omit
the rate. Use a second query where you join this query to the table on the
common fields.

 

[dhoover via AccessMonster.com]

I tried this, and I still get muilples for each.

That will happen if you included the Rate and the rates are different. Omit
the rate. Use a second query where you join this query to the table on the
common fields.

I have a query that looks that this:

[quoted text clipped - 9 lines]

I've tried using max date, but that's not woring like I need it to

 

[KARL DEWEY]

Post your query SQL.
--
KARL DEWEY
Build a little - Test a little

I tried this, and I still get muilples for each.

That will happen if you included the Rate and the rates are different. Omit
the rate. Use a second query where you join this query to the table on the
common fields.

I have a query that looks that this:

[quoted text clipped - 9 lines]

I've tried using max date, but that's not woring like I need it to