I had a quick question if anyone had any help it would be greatly appreciated.



I want to add a column to an existing database/spreadsheet. In this column will either be a Yes or a No.

The value will be Yes if the person's date of birth matches one of the date of births listed on another spreadsheet.

I would do this the tedious way by going row by row and matching each date of birth, but the spreadsheet/database has over 5,000 entries and time is a factor.

Is there a way to do this through either Excel or Access? I tried establishing relationships between the two databases but I don't know how to create a conditional script for this. Do I need to use SQL join scripts?

Is this easier than I'm making it out to be?

Thanks in advance for any help on this.