Recent content by blander

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

Cheers FoFa, I really appreciate all you help.. you have saved me heaps and heaps of time and a headache!!

Thanx so much for all ur help :)

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..

Thanks FoFA, But; The CatBel table does not contain the Email field since the CatBel table is made up of the MemID and the CatID, the link is made between the MemID in the Members table and CatID in the Category Table... hence it contains only three fields - CatBelID, MemID and CatID The...

Thanks FoFa i'll give it a go.. Really appreciate the help :)

Thanks FoFa ok so i'll explain the entire process of what i am trying to achieve.. (This is a bit of a long story) I have contacts - heaps of them (25k) They all belong to a certain category - (like Mail List (one category) and Northern Contacts (another category) for example) Each contact...

Thanks for you help but it looks like they are blank fields and not null - (imported from excel where some of the fields were blank) would i put IS NOT =" "; ok so that dosent work... any ideas?? Cheers Ben

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...

Cheers guys, Really appreciate it!!

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...