I have two databases (2013 and 2014) which are identical - all objects (tables, queries, reports etc) from 2013 copied to a blank db. I then deleted al the data from the Expenses table, entered new data in the Expenses table and renamed the db 2014. The rest of the tables remained unchanged.
I have a Select query which prompts for two required months, calculates the VAT amount for each purchase and then gives a monthly summary of the total purchases and VAT amounts paid at the different VAT rates for each respective month. The query works fine in the 2013 db but in 2014 db it returns "The expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." The culprit I assume is the expression "Vat Amount: Sum(CCur([Expenses].[Amount]*[Expenses].[VAT%]/100))". The only other expression is "Month: Format$([Date],"mmm",0,0)" requesting the input of the two relevant months. Both were copied several times for the 2013 db to the 2014 db with the same result.
Vista 32bit
Office Pro 2007
I even appended the 2014 table's data to the 2013 table which then make the 2013 db returning the same error message as well. I thus assume the problem must be in the 2014 Expenses table but I don't know how to find it. Even in design view the two tables are the same.
Only object dependencies differ but I don't know how to change it.