Results 1 to 4 of 4
  1. #1
    dougdrex is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    49

    Error message that states the field is too small to accept the amount of data you attempted to add.

    Using Access 2010.



    I'm getting an error message that I've never seen before. Below is a screen shot of the query, and then a screen shot of the error message. Can anyone tell me what I'm doing to cause the error?

    Click image for larger version. 

Name:	ErrorMsg.JPG 
Views:	17 
Size:	39.6 KB 
ID:	19084

    Click image for larger version. 

Name:	ErrorMsg2.JPG 
Views:	17 
Size:	18.0 KB 
ID:	19085


    Many thanks!
    Doug

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,507
    Why are you not linking on the PK field BankAccountID? The queries should include that field.

    I don't understand why you would get that error. Is this just a SELECT query?

    Why is there a BeginningBalance field? Beginning account 'balance' should just be a deposit transaction record.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dougdrex is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    49
    Sorry it took so long for me to respond. The holidays were super busy, then year-end created a hectic schedule as well.

    I've attached the db for analysis.

    Thanks very much!
    Doug
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,507
    I still think the aggregate queries should group on the AccountID instead of name. Don't include the REF_BankAccounts table in the aggregate queries.. Then join the aggregate queries to REF_BankAccounts on the ID fields.

    I changed the Currency fields to Number (double) type and removed Currency formatting and changed the aggregate queries to group by account ID fields and linked on ID fields. Qry_All_Balances now works.

    I never use Currency type and I never set formatting in tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Field too small to accept the data
    By Jonibenj in forum Access
    Replies: 6
    Last Post: 12-02-2014, 08:42 PM
  2. Error Message associated with Field
    By CQCDave in forum Access
    Replies: 15
    Last Post: 11-15-2014, 10:46 AM
  3. Replies: 12
    Last Post: 01-30-2014, 01:13 PM
  4. Error Message 3163 "field is too small...."
    By reggieara in forum Forms
    Replies: 3
    Last Post: 01-22-2014, 08:30 PM
  5. Run-time Error 3163 - Field Too Small
    By CementCarver in forum Programming
    Replies: 4
    Last Post: 07-23-2013, 09:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums