Enter "yes" or "no" in a table field based on another table

[cmartinezn]

Hi,

I apologize if this problem has been discussed in another thread. I have not been able to find it in this forum.

I have basic knowledge of Access and I am facing the following situation. I have to import 2 different Excel spreadsheets into Access. That's not a problem. One of them contains a list of employees and some details (including their ID number). So the fields for each register would be ID, Name, Last Name, DOB, Region, and so on. The other table is just a list of some of those employee's IDs. Not all the IDs are listed in this second table.

My problem is, I've been asked to add a new field in the first table, the one with the employee details, that has to show "yes" or "no", based on if that employee's ID appears in the second table or not.

Could anyone give me some hints on how to proceed? Thank you very much.

[June7]

Add the field to Table1 manually - a Yes/No field I guess.

Build an UPDATE query using the query builder.

Join the two tables on the ID fields, join type "Include all records from Table1 and only those from Table2 that match".

Under the new field on the Update To row:

IIf(IsNull(Table2.ID), No, Yes)

Test this on copy of the destination table first.

[ItsMe]

Add a new column to the table. Give the field a Yes/No data type. Give it a default value of 0.

Create a SELECT query Joining the ID's. Turn your SELECT query into an UPDATE query using the Update button in the ribbon. Update your yes no field to True and run the query.

Build a second UPDATE query based on the first table. Show all records WHERE the yes no field is null. UPDATE those records to = FALSE

[cmartinezn]

Thank you so much for your help. Although I'm not very used to work with Access, I believe I will be able to follow your suggestions. It's the first time that I read about "update query" though

I really appreciate the time you took to answer my question and I hope you don't mind if I get back to you if I still find myself stuck with this problem.

[ItsMe]

I suggest you spend some time to understand different approaches to managing nulls in yes no fields. There are two approaches in the two examples here.

[cmartinezn]

Will do, thanks!!