tractorvix
Technical User
Does anyone know how to stop a make table query erroring with a numeric field overflow. I assumed that as it was a 'make' table query it would set the field sizes appropriately. it runs fine the first time round, but when I try to run it again, I get the error.
I've also tried using an append query to do this and get the same error.
code below
SELECT InStr(Mid([RMS Data]![Staff Name],3,6),"-") AS rmsidbuild, Left([RMS Data]![Staff Name],(1+[rmsidbuild])) AS RMSID, [RMS Data].[Career Path] AS RoleID, [RMS Data].[Project Cost Centre] AS CC, [RMS Data].Month, [RMS Data].[HOIT Name] AS Area, [RMS Data].Direct, [RMS Data].[Project Owner] AS LineMgr, [RMS Data].Demand, InStr([RMS Data]![Developer Sub Group]," Developers") AS skillbuild, IIf([RMS Data]![Developer Sub Group] Is Null,"",Left([RMS Data]![Developer Sub Group],[skillbuild])) AS Skill, [RMS Data].Vacancy, [RMS Data].[Capability Res Type] INTO tblbuildRMS
FROM [RMS Data]
WHERE ((([RMS Data].Vacancy)="true") AND (([RMS Data].[Capability Res Type]) Like "1*") AND (([RMS Data].[Project Title]) Not Like "zz*"));
Thanks
Vix
I've also tried using an append query to do this and get the same error.
code below
SELECT InStr(Mid([RMS Data]![Staff Name],3,6),"-") AS rmsidbuild, Left([RMS Data]![Staff Name],(1+[rmsidbuild])) AS RMSID, [RMS Data].[Career Path] AS RoleID, [RMS Data].[Project Cost Centre] AS CC, [RMS Data].Month, [RMS Data].[HOIT Name] AS Area, [RMS Data].Direct, [RMS Data].[Project Owner] AS LineMgr, [RMS Data].Demand, InStr([RMS Data]![Developer Sub Group]," Developers") AS skillbuild, IIf([RMS Data]![Developer Sub Group] Is Null,"",Left([RMS Data]![Developer Sub Group],[skillbuild])) AS Skill, [RMS Data].Vacancy, [RMS Data].[Capability Res Type] INTO tblbuildRMS
FROM [RMS Data]
WHERE ((([RMS Data].Vacancy)="true") AND (([RMS Data].[Capability Res Type]) Like "1*") AND (([RMS Data].[Project Title]) Not Like "zz*"));
Thanks
Vix