Hi guys,
I'm fairly new to MS Access and I am running Ver.2003.
I have a problem with comparing a Excel speadsheet with an Access DB.
The result I require is as follows....
If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then place 'Y' in MBR field ( 1st field) in Excel speadsheet else 'N'
The 'Y' and 'N' can be a numeric if this is easier and I could then change the numeric to a alpha 'Y' or 'N' later.
If anyone can help me I would be extremely grateful.
Thanks
Ashley