Math on Tab Control

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I'm working with tab controls for the first time. The
information is populating correctly. However, when I try
do have a text field do math, such as subtract two
numbers, the result is #NAME?

For example, on a tab called Income Statement Trend, I
have a field for Net Income. The calculation I have is
=GrossIncome-Expense where GrossIncome and Expense are
field names in the underlying table.

I've tried using the field names and using the names of
their text boxes. Do I have to refer to the tab name?

Thanks for your advice.

Nancy
 
Better to use a Calculated Field in the Query and simply use a TextBox
Control to display the Calculated Field value in this case.
 
Back
Top