View Single Post
 
Old October 24th, 2006, 07:00 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   Without seeing your database structure, I would propose an extra field in the Employee table to indicate the location of the employee, if it isn't already in there. Perhaps even a field containing the multiple itself. For example:

tblEmployee
PK
FName
LName
Location
WorkHours = 8, 9

Then use the WorkHours field in your query to get the multiple. It could be 8, 9, 40, or 45 as needed.

Does that help?


mmcdonal