Connecting Tech Pros Worldwide Help | Site Map

mulitiplication calculating expression

Newbie
 
Join Date: Oct 2008
Posts: 1
#1: Oct 12 '08
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's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Oct 12 '08

re: mulitiplication calculating expression


Quote:

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:

Expand|Select|Wrap|Line Numbers
  1. SELECT [Hours/Week]*[Wage Rate] as [Weekly Wage]
  2. from YOURTABLE
-- CK
Reply