Professional Web Applications Themes

Math on Tab Control - Microsoft Access

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...

  1. #1

    Default Math on Tab Control

    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
    Nancy Guest

  2. #2

    Default Re: Math on Tab Control

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

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Nancy" <catspawusfamily.net> wrote in message
    news:0dbc01c34d2d$14d38760$a301280aphx.gbl...
    > 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

    Van T. Dinh Guest

Similar Threads

  1. math problem will Math.floor help
    By javman webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 5
    Last Post: February 4th, 01:28 AM
  2. Replies: 4
    Last Post: December 19th, 07:09 AM
  3. Math::RungeKutta ?
    By Peter Billam in forum PERL Modules
    Replies: 4
    Last Post: December 1st, 05:46 AM
  4. OT: Math help
    By Joseph D. DeJohn in forum ASP.NET General
    Replies: 2
    Last Post: August 7th, 02:52 AM
  5. Replies: 2
    Last Post: July 2nd, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139