Max date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "dhoover via AccessMonster.com" <u26355@uwe>
Date: Thu, 30 Aug 2007 14:21:28 GMT

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200708/1

.

Prev by Date: Re: Help with relative date
Next by Date: Calculation problem
Previous by thread: Re: Help with relative date
Next by thread: RE: Max date
Index(es):
- Date
- Thread

Relevant Pages

RE: update query with summary
... Use a totals query with criteria of zero on the sum, ... Use that query INNER join on both fields in your delete query. ... customer1 LA -100.00 ... customer2 is different in city, i don't want that field to be closed. ...
(microsoft.public.access.queries)
The column prefix MS1 does not match with a table or alias name used in the query. (#107)
... One query looks like this, ... SELECT Customer1 overall.*, ... Customer1 Field, Customer1 Staff, and Customer1 Overall are each ... queries with certain where clauses. ...
(comp.databases.ms-access)
Re: Need expert assistance with this (MySQL routine)
... Hmm, now after changing that now I get parse error, unexpected '}' in ... > The query is valid, so are you sure the table customer1 exists? ...
(alt.php)