Max date

  • Thread starter dhoover via AccessMonster.com
  • Start date
D

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
 
K

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.
 
D

dhoover via AccessMonster.com

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

KARL said:
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
 
K

KARL DEWEY

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


dhoover via AccessMonster.com said:
I tried this, and I still get muilples for each.

KARL said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top