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.