Access 2007: Create Expression as Field in the Table

[diane802]

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?

[RuralGuy]

To start with, you do not want to store a calculation in a table for a number of reasons. Second, create a query that performs the calculation for you.

[diane802]

once I have created it in a query, how do I add this field to show up in my form?

[RuralGuy]

Calculated query fields are just as real as table fields to a form. Just bind your control to that field.

[diane802]

Sorry - first time I am doing this.

I have created a text box in the form. Then under Design view, I went to Property Sheet / Data tab:
Control Source - I made it equal to the field from the Query I want to show

When I go back to View, it shows the Name error: #Name?

What am I doing wrong?

[RuralGuy]

Have you bound the form to your query with the calculation? When you selected the ControlSource, did you use the cbo DropDown to select the field?

[diane802]

Apologies I figured it out thanks.

[RuralGuy]

Glad I could help.