Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    37

    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 ?

    Thanks

    Jason

  2. #2
    Join Date
    Oct 2003
    Posts
    706
    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."
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Dec 2003
    Posts
    37
    sundialsvcs Thank you so much for you quick reply that worked 100% the way I want

    Again Thanks

    JD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •