Search results

Hi, I am trying to normalize some data into some tables and am struggling a little. The data contains some normal client data such as: First Name Last Name Address And also data such as: income range - 20-50, 50-80, 80-100 etc acquisition method: Radio, television, mailing etc Each record...

Hi guys, The following query DELETE DD5592.* FROM DD5592, [module] WHERE DD5592.Sortcode=module.BASortCode; Results in a message: Cannot delete from the specified tables. Any ideas??

Hi Guys, Two Tables: module workbook2 UPDATE workbook2 INNER JOIN [module] ON workbook2.ID = module.ID SET workbook2.bankimpid = module.BAImpID WHERE ((([BASortCode])=[Sortcode])); Any ideas why this changes 0 records when some records contain the same data in BASortCode and Sortcode?? Cheers

Hi Guys, I have run the find duplicates wizard, but as many others cannot delete the duplicates and leave one field behind. I have the following query where it finds the records based on FIRSTNAME, LASTNAME and ORGAN DELETE NullEmail.FIRSTNAME, NullEmail.LASTNAME, NullEmail.ORGAN...

Hi guys, Why wont this query work?? DELETE Work.MemID FROM Work2 INNER JOIN [Work] ON Work2.EMAIL = Work.EMAIL WHERE (((Work.MemID)<>[Work2].[MemID])); Two tables as you can see.. And all i want to do is delete records in one table which dont have the same MemID in another table..

Hi guys, I have 23k records I have run the wizard to find all the duplicates according to one field. So i have the results, except that some of the records contain nothing within the searchable field - so it returns all the records with nothing in the searchable field as duplicates. How...

Hi guys, I am implementing a new database (Access 2000) for my company. It contains contact details of a subscription base. Four tables are present MEMBER, ORGANISATION, EVENTS and CATEGORY. My problem is; people attend events, and i want to record this in the database. Each event has an...