Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    May 2005
    Posts
    215
    Thanks
    14
    Thanked 0 Times in 0 Posts

    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

    Code:
    ?
    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...

    Code:
    
    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)

    Code:
    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

  • #2
    Regular Coder
    Join Date
    May 2005
    Posts
    215
    Thanks
    14
    Thanked 0 Times in 0 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •