该字段太小，无法接受大量数据......（需要紧急帮助） [英] The field is too small to accept the amount of data... (URGENT HELP NEEDED)

问题描述

我正在做一些大学课程，我已经创建了一个查询从数据库中提取一些数据，但我一直收到错误'该字段太小，无法接受数据量......'而且我没有任何线索我做错了什么。



这是我写的：

I am doing some university coursework, and i have created a query to extract some data from the database but i keep receiving the error 'the field is too small to accept the amount of data...' and i have no clue what i have done wrong.

Here is what i have written:

SELECT SMM.StudentId, Student_Module.YearStudied, AVG(SMM.FinalMark) AS AverageMarks
FROM SMM, Student_Module, Student
WHERE Student.StudentId=SMM.StudentId
AND SMM.StudentId=Student_Module.StudentId
AND SMM.ModuleCode=Student_Module.ModuleCode
AND Student_Module.ModuleCode=Module.ModuleCode
AND Student.GraduationDate="09/08/2013"
AND YearStudied>1
GROUP BY SMM.StudentId, YearStudied; 

UNION SELECT SMM.StudentId, "DegreeResult" AS YearStudied, AVG( SMM.FinalMark) AS AverageMarks
FROM SMM, Student_Module, Student
WHERE Student.StudentId=SMM.StudentId
AND SMM.StudentId=Student_Module.StudentId
AND SMM.ModuleCode=Student_Module.ModuleCode
AND Student_Module.ModuleCode=Module.ModuleCode
AND Student.GraduationDate="09/08/2013"
AND YearStudied>1
GROUP BY SMM.StudentId;

当我转到'StudentModule'并将'YearStudied'中的数据类型更改为文本时，错误更改为'数据类型不匹配'
任何帮助都会非常感激（PS我是Access的初学者）





添加了 pre 标签。

[/编辑]

推荐答案

Quote：

你可以有一个输入数据较大的Integer字段，或者输入文本较长的文本字段，或者那种类型的东西。您可以通过逐个删除字段找到它，直到找到有问题的字段，或者从一个安全字段开始并开始添加字段，直到找到坏字段为止。

You could have an Integer field where the incoming data is larger, or a text field with a small width where the incoming text is longer, or that type of thing. You might be able to find it by eliminating fields one at a time until you find the offending one, or start with one safe field and start adding fields until you find the bad one.

检查此链接。希望它可以帮助您解决问题



在Access中运行查询时出现错误消息：该字段太小，无法接受您尝试添加的数据量 [ ^ ]

Check this link. Hope it helps your issue

Error message when you run a query in Access: "The field is too small to accept the amount of data you attempted to add"[^]

这篇关于该字段太小，无法接受大量数据......（需要紧急帮助）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！