ThaiByThai
Registered User.
- Local time
- Today, 13:49
- Joined
- Aug 12, 2009
- Messages
- 21
Hi all -
I just updated a field in our master database with people DOB that matches their emp ID - I need to do a mass update in the comment field that say "Updated on 4-4-2011" but does not delete the the current comment that is already there in the comment field - i'm not sure how to go about doing this... i am using access 2007 and i try the append but that fail...
SELECT [MASTER DATABASE].ID, [MASTER DATABASE].[Birth Date], [MASTER DATABASE].Comment
FROM [MASTER DATABASE] RIGHT JOIN [DOB Query] ON [MASTER DATABASE].ID = [DOB Query].ID;
I just updated a field in our master database with people DOB that matches their emp ID - I need to do a mass update in the comment field that say "Updated on 4-4-2011" but does not delete the the current comment that is already there in the comment field - i'm not sure how to go about doing this... i am using access 2007 and i try the append but that fail...
SELECT [MASTER DATABASE].ID, [MASTER DATABASE].[Birth Date], [MASTER DATABASE].Comment
FROM [MASTER DATABASE] RIGHT JOIN [DOB Query] ON [MASTER DATABASE].ID = [DOB Query].ID;