Please Help

[mama16]

I am trying to get the highest value. Actually, I did get the highest value, but when I added another field "Month Year" things got messed up( I got all the values and all the dates) so I tried to create a sub query and I don't think I'm doing it right. Can someone please help me with the syntax.

I want to get the highest value along with their dates

Thank you

SELECT Deployers.Deployers, MaxStatistics.Tot_calls_by_Month) As Total
FROM Deployers INNER JOIN Statistics ON Deployers.Deployers = Statistics.Deployers
Where Statistics.MonthYear in

( SelectDeployers.Deployers, Statistics.MonthYear
from Deployers INNER JOIN Statistics ON Deployers.Deployers = Statistics.Deployers);

 

[dhookom]

1) you should find a better subject line rather than "Please Help"
2) you shouldn't get to threads going based on the same question. There is at least one reply in the queries group where this thread should probably be directed.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]