MS Access

[Rich Sherman]

How do you setup or can you setup a subquery that would give you the max records for all clients for a parameter date provided. I know it would have t o check max records by client and have done this in separate queries but wondered if it can be in a subquery within the table.

Appreciate it.

EggHeadCafe - Software Developer Portal of Choice
Build an Anthem.Net Remote Scripting (AJAX) AutoSuggest Textbox control
http://www.eggheadcafe.com/tutorial...64-f222ded907ff/build-an-anthemnet-remot.aspx

 

[vanderghast]

What do you mean by "max records"? If it is something like, say, the
maximum cost, then:

SELECT client, MAX(cost)
FROM table
WHERE dateStamp = [ enter date ]
GROUP BY client


would do.


Vanderghast, Access MVP

in message news:[email protected]...