Access Query with Where Clause Not Returning Results - Microsoft Community

i having issue access query. reason, access query not returning results when filtering agent_name field. query so..

select agents.supervisor, agents.agent_name, agents.agent_id, qry_utilization_clean.month, sum(qry_utilization_clean.logged_in) ut_logged_on, sum(qry_utilization_clean.production) ut_production, sum(qry_utilization_clean.calls) ut_calls, sum(qry_utilization_clean.talk) ut_talk, sum(qry_utilization_clean.preview) ut_preview_wrap, sum(qry_dispositions_clean.dis_calls) d_calls, sum(qry_dispositions_clean.success) d_successful, sum(qry_dispositions_clean.unsuccess) d_unsuccessful, sum(qry_dispositions_clean.dis_complete) d_complete, sum(qry_quality_csat_clean.qscore) q_score, sum(qry_quality_csat_clean.cscore) csat_score
((agents inner join qry_utilization_clean on agents.agent_id = qry_utilization_clean.agent_id) inner join qry_dispositions_clean on (qry_utilization_clean.agent_id = qry_dispositions_clean.agent_id) , (qry_utilization_clean.month = qry_dispositions_clean.month)) inner join qry_quality_csat_clean on (qry_utilization_clean.agent_id = qry_quality_csat_clean.agent_id) , (qry_utilization_clean.month = qry_quality_csat_clean.month)
group agents.supervisor, agents.agent_name, qry_utilization_clean.month, agents.agent_id
order agents.supervisor, agents.agent_name, qry_utilization_clean.month;

the query returning requested information. now, problem lies, in spreadsheet view, when click on agent_name column, , attempt filter. list of agent names check boxes, expect. however, when remove , select single name (any name) 0 results. same response when attempt run same query above agents.agent_name ="lastname, firstname" (using name know in list). query runs, but, 0 results.

i have gone agents table, , can filter agent_name, have been able run simple distinct query on agents table agent_name , can sort agent name. reason, cannot above query recognize individual names in query results.

any appreciated.

hi blaine,

your microsoft access question more complex typically answered in microsoft answers forums. best post query in access forums found in microsoft technet forum. have experts there can answer query.

you may post here.

feel free post should need further assistance.

Office / Access / Other/unknown / Office 2010