Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using MS Access database. I have a table (Proposal) with the following properties: ProposalID - PK, Title, RequestedAmount, ResearcherID - FK

I want to run an SQL query to get the candidate that has requested for the highest amount. My query that didn't work is:

Select ProposalID, Title, Max(RequestedAmount) AS Budget, ResearcherID

I get this error:

You tried to execute a query that does not include the specified expression 'ProposalID' as part of an aggregate function

How can I fix this?

share|improve this question
up vote 0 down vote accepted

If you want to use aggregated fields with not aggregated fields you will have to use Group by with the not aggregated fields. But in your case IMHO you are searching for:

Select ProposalID, Title, RequestedAmount AS Budget, ResearcherID
where RequestedAmount=(Select Max(RequestedAmount) from Proposal)
share|improve this answer
what about ties? – Mitch Wheat May 10 '13 at 7:24
@MitchWheat I know Tie from SQL-Server, do you know from MS-Access? – bummi May 10 '13 at 9:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.