Error 3163 Couldn't Insert or Paste; Data Too Long for Field

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I do not understand how this is happening. It is a Select
query that is combining 2 tables in Access 2000. It is
not appending or updating any other tables. How can I be
getting this error message. What is it doing or what am I
doing wrong???
 
Rick,

Could you please open your query in SQL View and copy and paste the code
here?


Sincerely,

Chris
 
Here it is:
SELECT DISTINCT Employees.EmployeeID, [Employees].
[lastname] & ", " & [Employees].[firstname] & " " &
[Employees].[middleintial] AS Name, Employees.Active,
Employees.Company, Employees.Department AS D,
Time.WeekEndingDate, Employees.SocialSecurityNum, Time.Job
FROM Employees INNER JOIN [Time] ON Employees.EmployeeID =
Time.EmployeeID
WHERE (((Employees.Active)=Yes) AND ((Employees.Department)
="1" Or (Employees.Department)="2" Or
(Employees.Department)="7" Or (Employees.Department)="8")
AND ((Time.WeekEndingDate)=[Forms]!
[ReportPaycheckDistributionSelection]![Q_DATE]));
 
I would GUESS that using Name as the name for a column may be the cause of your
problem. The first thing I would try would be to use brackets around name or
change it to FullName or EmployeeName.

SELECT DISTINCT Employees.EmployeeID,
[Employees].[lastname] & ", " & [Employees].[firstname] & " " &
[Employees].[middleintial] AS [Name], Employees.Active,
Employees.Company, Employees.Department AS D,
Time.WeekEndingDate, Employees.SocialSecurityNum, Time.Job
FROM Employees INNER JOIN [Time] ON
Employees.EmployeeID = Time.EmployeeID
WHERE Employees.Active=True AND
Employees.Department in ("1","2","7","8")
AND Time.WeekEndingDate)=[Forms]![ReportPaycheckDistributionSelection]![Q_DATE];


Here it is:
SELECT DISTINCT Employees.EmployeeID, [Employees].
[lastname] & ", " & [Employees].[firstname] & " " &
[Employees].[middleintial] AS Name, Employees.Active,
Employees.Company, Employees.Department AS D,
Time.WeekEndingDate, Employees.SocialSecurityNum, Time.Job
FROM Employees INNER JOIN [Time] ON Employees.EmployeeID =
Time.EmployeeID
WHERE (((Employees.Active)=Yes) AND ((Employees.Department)
="1" Or (Employees.Department)="2" Or
(Employees.Department)="7" Or (Employees.Department)="8")
AND ((Time.WeekEndingDate)=[Forms]!
[ReportPaycheckDistributionSelection]![Q_DATE]));
-----Original Message-----
Rick,

Could you please open your query in SQL View and copy and paste the code
here?


Sincerely,

Chris




.
Click to expand...
Click to expand...
 
Rick said:
Here it is:
SELECT DISTINCT Employees.EmployeeID, [Employees].
[lastname] & ", " & [Employees].[firstname] & " " &
[Employees].[middleintial] AS Name, Employees.Active,
Employees.Company, Employees.Department AS D,
Time.WeekEndingDate, Employees.SocialSecurityNum, Time.Job
FROM Employees INNER JOIN [Time] ON Employees.EmployeeID =
Time.EmployeeID
WHERE (((Employees.Active)=Yes) AND ((Employees.Department)
="1" Or (Employees.Department)="2" Or
(Employees.Department)="7" Or (Employees.Department)="8")
AND ((Time.WeekEndingDate)=[Forms]!
[ReportPaycheckDistributionSelection]![Q_DATE]));
-----Original Message-----
Rick,

Could you please open your query in SQL View and copy and paste the code
here?


Sincerely,

Chris
Click to expand...
Click to expand...

SELECT DISTINCT

Employees.EmployeeID

,[Employees].[lastname] & ", " &

[Employees].[firstname] & " " &

[Employees].[middleintial] AS Name

,Employees.Active

,Employees.Company

,Employees.Department AS D

,Time.WeekEndingDate

,Employees.SocialSecurityNum

,Time.Job

FROM Employees

INNER JOIN

[Time]

ON Employees.EmployeeID = Time.EmployeeID

WHERE (((Employees.Active) = Yes)

AND ((Employees.Department) = "1"

OR (Employees.Department) = "2"

OR (Employees.Department) = "7"

OR (Employees.Department) = "8")

AND ((Time.WeekEndingDate) =

[Forms]![ReportPaycheckDistributionSelection]![Q_DATE]));





Hmmm.



Without being able to examine your Tables or Form in detail, it's very
hard to tell for sure.



Off the top of my head, I don't know.



However, a little googling produces:



http://support.microsoft.com/support/kb/articles/q121/5/12.asp



ACC: "Couldn't Insert or Paste; Data Too Long for Field" Error Message



CAUSE



This error occurs if one of the fields in the record has a default value
that exceeds that field's FieldSize property setting.



RESOLUTION



Increase the field's FieldSize property setting to be equal to or larger
than the field's default value. Or, change the field's default value so that
it does not exceed the field's FieldSize property setting.





It does note that it applies to Access 97 and earlier, but I don't know
which version you're using.





Sincerely,



Chris O.
 
Back
Top