Make Table query - Checkboxes

[scottemotive]

Hi i have a make table query that outputs a normalised database to text format (bringing linked info from another table) but checkboxes that are 1 on the source table are being output on the new table as -1
anyone know why this is, and how i can fix it?
thank you

SQL:
SELECT [CMS Compliance Table].ID, [CMS Compliance Table].[Policy Number], tblEmployee.EmployeeName, tblDepartment.DepartmentName, tblManager.ManagerName, tblComplianceAgents.ComplianceAgentName, [CMS Compliance Table].Date, [CMS Compliance Table].[Closing Action], [CMS Compliance Table].Nature, [CMS Compliance Table].Specific, [CMS Compliance Table].[Policy Logged Against], [CMS Compliance Table].[Complaint or Enquiry Flag], [CMS Compliance Table].[Justified or Unjustified], [CMS Compliance Table].[Holding Letter], [CMS Compliance Table].Suspended, [CMS Compliance Table].[Process at Fault], [CMS Compliance Table].Comments, [CMS Compliance Table].[Agent ID], [CMS Compliance Table].[Assosciated CMS], [CMS Compliance Table].[Discount Given], [CMS Compliance Table].[Root Cause Failed], [CMS Compliance Table].TotalRecs INTO CMSTableOutput
FROM tblComplianceAgents INNER JOIN (tblDepartment INNER JOIN (tblEmployee INNER JOIN (tblManager INNER JOIN [CMS Compliance Table] ON tblManager.ManagerID = [CMS Compliance Table].TeamManager) ON tblEmployee.EmployeeID = [CMS Compliance Table].AgentName) ON tblDepartment.DepartmentID = [CMS Compliance Table].Department) ON tblComplianceAgents.ComplianceAgentID = [CMS Compliance Table].ComplianceAgent
WITH OWNERACCESS OPTION;