icemonster
03-07-2010, 08:40 PM
any ideas how to do this? i have a field that calculates number of hours, and i have a field that has rate, how do i get it to calculate?
|
View Full Version : calculate hours work with rate? icemonster 03-07-2010, 08:40 PM any ideas how to do this? i have a field that calculates number of hours, and i have a field that has rate, how do i get it to calculate? pbaldy 03-07-2010, 09:00 PM In query design view TotalAmount: [HoursFieldName] * [RateFieldName] icemonster 03-08-2010, 09:14 AM so, mr baldy, what if the field am trying to calculate was just an expression? like: Hrs Per Day: CalcHoursPerDay([tblSchedule]![StartHr],[tblSchedule]![EndHr]) and i have a table that says rate: how do i multiply them both? icemonster 03-08-2010, 09:16 AM woot figured it out. :D :D :D |