I have a table where I want to create a calculation based upon two other fields in the table.
I am in Design View of this table.
I created the Field Name, Data Type: Number
Under Field Properties, I am on the General tab, and under "Default Value", I clicked on the "Build ..." button, but when I open it - it does not show any of my Table fields (which usually does exist in Form view).
I tried typing in the calcuation by doing:
=[Field 1 Name] * [Field 2 Name]
But when I click View table - it says:
The database engine does not recognize either the field 'Field 1 Name' in a validation expression, or the default value in the table 'Table 1'
Advice please?