mulitiplication calculating expression

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • joannarchie
    New Member
    • Oct 2008
    • 1

    #1

    mulitiplication calculating expression

    I am tring to write a multiplication expression but keep getting needing a perimeter value which I do not need. I need to have hours/week and wage rate to multiply together.

    My expression looks like this. Weekly Wage:[Hours/Week]*[Wage Rate]
    My table has these numbers in these two fields. Please Help me I need to know for a grade at school.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Originally posted by joannarchie
    I am tring to write a multiplication expression but keep getting needing a perimeter value which I do not need. I need to have hours/week and wage rate to multiply together.

    My expression looks like this. Weekly Wage:[Hours/Week]*[Wage Rate]
    My table has these numbers in these two fields. Please Help me I need to know for a grade at school.

    Try:

    Code:
    SELECT [Hours/Week]*[Wage Rate] as [Weekly Wage]
    from YOURTABLE
    -- CK

    Comment

    Working...