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

[dougdrex]

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?








Many thanks!
Doug

[June7]

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.

[dougdrex]

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

[June7]

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.