Calculated feilds

Discussion in 'Microsoft Access Queries' started by Guest, Apr 17, 2005.

  1. Guest

    Guest Guest

    I need to have a caculated field named Overhead that displays the results of
    TotalPleged multiplied by 15% I an having trouble building the expression I
    enterd Overhead:[Totalpleged]*15% and it tells me I have enter an operand
    without an operator what do I do .
     
    Guest, Apr 17, 2005
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    I'm not sure, but try to enter :[Totalpleged]*1.15 incase you want an extra
    15% for your price

    "constance" wrote:

    > I need to have a caculated field named Overhead that displays the results of
    > TotalPleged multiplied by 15% I an having trouble building the expression I
    > enterd Overhead:[Totalpleged]*15% and it tells me I have enter an operand
    > without an operator what do I do .
     
    Guest, Apr 17, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. David Ehrenreich

    Compare Time feilds.

    David Ehrenreich, Nov 17, 2003, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    181
    [MVP] S. Clark
    Nov 17, 2003
  2. Tim

    Combining 2 Text Feilds

    Tim, Dec 4, 2003, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    239
  3. Gravey

    Append Query - 18 feilds to external database

    Gravey, Jan 30, 2004, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    396
    Gravey
    Feb 2, 2004
  4. Raashid
    Replies:
    1
    Views:
    533
    Michel Walsh
    May 5, 2004
  5. SUB

    Many feilds one criteria

    SUB, Aug 11, 2004, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    224
  6. Guest

    Calculated feilds

    Guest, Apr 17, 2005, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    259
    Allen Browne
    Apr 17, 2005
  7. Guest

    Problem with a query comparing multiple feilds

    Guest, Jul 10, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    265
    Michel Walsh
    Jul 10, 2006
  8. Syed Zeeshan Haider

    Combining feilds

    Syed Zeeshan Haider, Sep 20, 2007, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    260
    Guest
    Sep 20, 2007
Loading...