Strange characters...

Hello all. I have a report that is printing funny characters in one field. All fields are using the same style, except that one of them is printing a question mark and a funny little square like below

?

I don't think it is in the code because if I put the same query in Access, all results are fine except that same column, which displays the following...



The funny thing is that another report that pulls the same data works fine, although the query is slightly different. By the way, this is a memo field.

Here is the query that is used: (problem column is in blue)

SELECT tblEmpInfo.dbEmpNo, tblEmpInfo.dbFirstName, tblEmpInfo.dbLastName, tblEmpInfo.dbTimesheetType, tblSubmitted.dbSubmitted, tblSubmitted.dbPrinted, tblEmpTime.dbEmpLogin, tblEmpTime.EmpName, tblEmpTime.EmpNumber, tblEmpTime.WorkDate, tblEmpTime.CustJob, tblEmpTime.CustCode, tblEmpTime.Phase, tblEmpTime.JobDesc, tblEmpTime.Hours, tblEmpTime.dbCaseNo, tblEmpTime.dbOrg, tblEmpTime.dbContract, tblEmpTime.dbSupervisor, tblEmpTime.dbAdmin, tblEmpTime.dbTestSU, tblEmpTime.dbTestOPS, tblEmpTime.dbTestCU, tblEmpTime.dbSiteMaint, tblEmpTime.dbFabrication, tblEmpTime.dbEquipment, tblEmpTime.dbTraining, tblEmpTime.dbHoliday, tblEmpTime.dbSupervision, tblEmpTime.dbSickPTO, tblEmpTime.dbOvertime, tblEmpTime.dbVacation, tblEmpTime.dbDayOfWeek, tblEmpTime.dbLocked, tblEmpTime.EmpLevel, tblEmpTime.FromDate, tblEmpTime.ToDate, tblEmpTime.JobTask, tblEmpTime.WorkYear, tblEmpTime.DateEntered, tblEmpTime.Location
FROM (tblEmpTime INNER JOIN tblEmpInfo ON tblEmpTime.dbEmpLogin = tblEmpInfo.dbEmpLogin) INNER JOIN tblSubmitted ON tblEmpInfo.dbEmpLogin = tblSubmitted.dbEmpId
GROUP BY tblEmpInfo.dbEmpNo, tblEmpInfo.dbFirstName, tblEmpInfo.dbLastName, tblEmpInfo.dbTimesheetType, tblSubmitted.dbSubmitted, tblSubmitted.dbPrinted, tblEmpTime.dbEmpLogin, tblEmpTime.EmpName, tblEmpTime.EmpNumber, tblEmpTime.WorkDate, tblEmpTime.CustJob, tblEmpTime.CustCode, tblEmpTime.Phase, tblEmpTime.JobDesc, tblEmpTime.Hours, tblEmpTime.dbCaseNo, tblEmpTime.dbOrg, tblEmpTime.dbContract, tblEmpTime.dbSupervisor, tblEmpTime.dbAdmin, tblEmpTime.dbTestSU, tblEmpTime.dbTestOPS, tblEmpTime.dbTestCU, tblEmpTime.dbSiteMaint, tblEmpTime.dbFabrication, tblEmpTime.dbEquipment, tblEmpTime.dbTraining, tblEmpTime.dbHoliday, tblEmpTime.dbSupervision, tblEmpTime.dbSickPTO, tblEmpTime.dbOvertime, tblEmpTime.dbVacation, tblEmpTime.dbDayOfWeek, tblEmpTime.dbLocked, tblEmpTime.EmpLevel, tblEmpTime.FromDate, tblEmpTime.ToDate, tblEmpTime.JobTask, tblEmpTime.WorkYear, tblEmpTime.DateEntered, tblEmpTime.Location
HAVING (((tblSubmitted.dbSubmitted)=-1) AND ((tblSubmitted.dbPrinted)=0) AND ((tblEmpTime.dbEmpLogin)='aearchi') AND ((tblEmpTime.WorkDate) Between #3/28/2007# And #4/3/2007#))
ORDER BY tblEmpTime.WorkDate, tblEmpTime.dbCaseNo;

Any suggestions would greatly be appreciated.

Thanks,

Parallon

Actually, I just found out that it has something to do with the GROUP BY and the Memo field.

Does Access not let you use a memo field when you use a GROUP BY?

Thanks,

parallon