var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: if statement in a report
hope someone can help with this one
I have a report which displays all the projects a employee has worked on. When the report is opened the user has to enter a employee number and the data is shown for that employee.
I want to add a field to show if the employee was the project leader with a value of either "Yes" or "No".
The querry would be like this if I could get it to work
if [PROJECTTEAM_EmpID] = [PROJECT].[EmpID] then "Yes" else "No"
could someone be so kind as to show me the correct syntax ?
I believe that Access has an "IIF" function for this purpose. But in this case there's a simpler way...
A calculated-field should also be useful here: the calculation is:
=([PROJECTTEAM_EmpID] = [PROJECT].[EmpID])
This produces a true/false result that can be displayed as "yes/no."
sundialsvcs Thank you so much for you quick reply that worked 100% the way I want