"ȉ
" - Why do these boxes keep appearing in my query results!

[bondidude]

I have written a query that has a table of Questions with a question_id and a question_description. This links to a table of results where there is a persons client_id, question_id and result_id. I am trying to write a query that averages the result_id per client per question, but displays it per question_description.

My query therefore has client_id, question_description and average(result_id), with the necessary join on question_id.

When i view the query results, in place of the question_description, I get "ȉ
" in all cases.

Does anyone know why?

 

[bondidude]

It is ok, panic over, I figured it out. I had question_description set up as a memo field and therefore Access had difficulty grouping on it.

Thanks anyway.