Search results

Revised - IIf function in a calculated query I have been working on this same problem and I am have a new approach. Create a calculated field that is an IIF function: IIF(Max([nethours]>44,[nethours]-(now here I want it to subtract the next min value in the hours to reassign...

I am not quite sure how to begin to solve this issue so I will give a bit of an explanation. I have a query that includes fields from T_employee and fields from T_courses, which is courses taught by each employee per semester and T_Additional, which is additional hours added to employees for...

Hello, I am from north east of Toronto in Canada. I am a novice to intermediate user. I have no formal programming training so this is the part that eludes me. I have been developing databases since the late 90's off an on. I am currently working on a project and I am happy to report that I...