Experts:
I need some assistance with streamlining a query. Attached DB contains the following:
- Table "tbl_JobTitleSkills" with 2 fields (50 sample records).
- Field [JobTitle] contains 5 distinct job titles.
- Query "qry01_Input" is a group-by query counting the number of job titles (e.g., 7, 13, 9, 15, 6).
- Query "qry02_Output" then utilizes the 1st query as a "helper" query in order to place the 5 counts into parentheses. For example, "Business Analyst (7)".
My question(s):
1. Do you know of a method/way that would allow me to eliminate the need for the helper query "qry01_Input" while still producing the results in the 2nd query?
2. If so, what does the SQL look like (for current query "qry02_Output") so that the job titles count will be placed into the parentheses "( )" based on counting directly from the table?
Thank you,
EEH