Weird symbols not in a memo field

[bbagini]

Hi guys, I've been having a lot of problems with a particular query which is returning strange symbols like ڗ. I've found a lot of information on this occuring with memo fields, yet I am not using any.

I'll give a quick overview. I have a form frmStaff, which has a staffid, projid, startDate. I want to run a query when projid is changed to grab the staffid,projid, startDate and endDate as the current date. And append this data to a table tblPreviousProjects(prevprojID, staffid,projid,startdate,enddate)

This is the query im using:

INSERT INTO tblPreviousProjects ( projid, staffid, startdate, enddate )
SELECT [Forms]![frmStaff]![projectid] AS projectid, [Forms]![frmStaff]![staffid] AS staffid, [Forms]![frmStaff]![projStartDate] AS startDate, Date() AS endDate;

I'm not having any issues with the running of the query at the correct time, just the returns of these weird symbols.
Any help is appreciated.

 

[bbagini]

All sorted. Had I just properly run the append query it works fine. Checking the actual data before doing so was producing these weird symbols.However it all appended fine to the actual table.