Run time error "Type Mismatch" After updating the Table Field

[Glen17]

Hello everyone. I have TableName and it has a field named as "Month" also I made a query that the data is based in TableName. AFTER updating the field "Month" in Table the ReportName giving me an error saying Run time error '13' type mismatch. By the way the "Month" field is Calculated as Data Type. Please help me with this problem. Thanks1

 

[Uncle Gizmo]

Try changing the field name Month to fldMonth...

Sent from my SM-G925F using Tapatalk

 

[CJ_London]

to follow on from Unc's comment - because Month is a reserved word and the name of a vba/sql function

Also calculated fields cannot be updated or indexed. The calculation can only be based on values in the record and has to be completed as part of the field definition in table design.