Hi All,
I'm a bit of a newbie to Access and have been struggling with this problem all night.
I have two tables: one is a list of employees with the unique ID being employee ID. The other table is just a list of employee IDs and is only for those employees who are receiving a bonus this year.
I have created a field called "bonus" in the main table and would it like it to display "yes" if the person is getting a bonus and "no" if they are not.
I have tried to do a make table query and use an iif statement in the bonus field, but I can't quite figure it out. The query keeps resulting in a table that shows only the employees that are getting a bonus.
I'm using an iif statement in the bonus field in query design view:
IIf([Employee]![Employee ID]=[Bonus![Employee ID],"yes","no")
As I said this just results in a query with only the employees that are getting bonuses rather than a field with all employees and a "yes" or "no"
This was pretty easy for me to do in Excel; I just wrote a Vlookup and it worked perfectly. I can't quite figure out in Access though.
Any ideas?
Thanks in advance for the assistance!