you need Where (Userid is not null) and (email is not null)
--- In ms_access@yahoogroups.com, Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote: > > Hello, > > i am using the code to insert values from the temp table to the main table. i only want to transfer all the records where email and userid is not null.... > CurrentDb.Execute "INSERT INTO LDAPUserList L (L.FullUserName,L.FirstName,L.LastName,L.Initial,L.UserID,L.Email,L.UserFolder,L.WorkOffline) VALUES SELECT LDAPUserListTemp.FullUserName,LDAPUserListTemp.FirstName,LDAPUserListTemp.LastName,LDAPUserListTemp.Initial,LDAPUserListTemp.UserID,LDAPUserListTemp.Email,LDAPUserListTemp.UserFolder,LDAPUserListTemp.WorkOffline FROM LDAPUserListTemp WHERE LDAPUserListTemp.UserID Is Not NULL OR LDAPUserListTemp.Email Is Not Null" > not sure why it doesn't work. > please help!!! > > thanks, > lyanne > > > > L y a n n e R h e e z a C. O n g > > > > > > > --------------------------------- > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. > > [Non-text portions of this message have been removed] >
