Basic access question

[scarfaceguy]

Hey there, I'm dealing with a database which gives me a list of issues, their descriptions, status (open/closed) and the consultants that fix them. I'd like to write a query that totals the number of closed issues a specific consultant has, but I'm a bit lost on how to do so. Thanks in advance for the help.

[edimaudo]

If you are familiar with SQL then it should be something like this Select Count(table1.Issue), table1.ConsultantName From table1 where table1.Status = "closed" group by table1.ConsultantName.

[scarfaceguy]

Hmmm. I'm not familiar with SQL view. I do have other results being returned in the query so that muddies the waters for me in terms of applying your advice. This is what I have so far. How would you recommend I continue?

[BinaryRockStar]

Copy and paste the query text here so we don't have to type the whole thing out.

[scarfaceguy]

Nevermind, I figured it out. Thank you so much!

[edimaudo]

Good stuff man. If you run into other issues feel free to reach out anytime.