Access 2010: the field is too small to accept the amount of data you attempted to add WITHOUT DISTINCT -

I know there are some questions about this access error message, but these are not related to my query DISTINCT key word Use

I have two common questions, credit is included and others are debited, they are grouped according to the month and category.

Eventually, I want a complete outer convergence on these two tables so that I have to subtract each result for each month of each class to achieve balance.

Although the entry does not allow full external connectivity, so I need to be outside the right outer union where zero is required.

Now I am trying to populate correctly on month and category ID field when I include external in a field, then it works as expected when I do it in another area It works as expected, but when I get involved in both areas, "this field is very low that you accept data attempts to add"

Table 1:

produced by:

 [code] select [transaction by category] [category] AS classID Monthly, NJ (SM ([transaction by category]] [amount] [ID] = [transaction by category], format ([account transaction]. [Date of transaction], "MM / or" [Transaction] where [account transactions]. [Transaction type] 
  
 Table 2:  
  <[categorization], format ([account transactions]. [Date of the transaction], "MM / yani") as the month of the month:  [id] [ng] = [transaction by category] [id] = [according to transaction] [amount]) , 0) from AS [Category Total] [transaction by category] INNER [account transaction] [account transaction] from [[transaction] where [account transactions]. [Transaction type] = format by group 8 ([account transaction]. [Transaction date], "MM / OR"), [transaction by category]. Join the correct one who gives me an error:  
  SELECT * FROM ((SELECT [transaction by category]] [Classid], format ([account Transaction]. [Transaction date], "MM / yay") Month year, NJ (SM ([transaction according to class] [amount]), 0) from AS [class total] [transactions by category] Inner Join [account transaction [transaction]] [transaction type] = format by 8 group ([account transaction]. [Date of transaction], "mm / yon [transaction] [category category]] [class sh Category]] [class return] in the form of correct [class return] (selection [transactions by category] [class] AS classID, format ([account transaction]. [Transaction date], "mm / or [ [ID]] [ID] = [SEM (transaction of transaction] [amount]), 0) from AS [class total] [transaction by category] INNER [account transaction] [ID] = [transaction by category] [Transaction] where [account transactions]. [Transaction type N] <8> [Group B] format ([account transactions] [Category of transaction], "MM / OR"), [transaction by category]. [Categorized]] [Category Returns] [Category Returns] [Category] = [Category debit] [Category] and [Category] Return]. [Month year] = [debit to class]. [Month year]);   
 It looks like this error occurs with a text field when I use the format, the Month year field becomes a text field? Even then, it is only 5 characters long, along with when I only work in the column for the month of the year, but only when I join the two fields only fails.   
 
 
 You are using the SQL Server as your back-end according to your tags. The problem you are experiencing is not from MS Access, but rather a combination of MS Access and SQL Server. The query will work entirely in the MS Access environment. (Yes, format converts to text.)  
 You can use to create a query that runs using SQL Server syntax and therefore you can use full external insertion, or You  
  edit the tag again   
 If any of your fields have a memo field, see. In such a complex query, it is best to trim the memo field under 255 or less.