I need to create some type of rule of exception for when a certain client is pulled up the standard calculation is different due to the geographical area.
In other words.
when a report is created for our employees in India - their work week should have the calculation of 52*45 in the total fields in place of the 52*40(52 weeks * 40 hours) for the US employees.
the calculation for the returned value is only in the final field created in the report. How do I add the exception to the report so that the valus will reflect for India 9-hour work days as opposed to 8 hour work day,(which is the 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