Search results

Lets say I have the following two text fields Field1= "Today is Monday" Field1 = "Today is Monday and it is sunny" If Field1<>Field2, I want to set Field3 = " and it is sunny" In other words I want to record the 'difference' between the two strings. I Venn Diagram language, I want to get...

I have imported a large number of emails into a table tbl_requests. I had intended to have unique file tbl_requests.date_opened unique, but have ended up with a lot of duplicate records (i.e. tbl_requests.date_opened is not unique !). Any idea how to delete any duplicates? I have 15,000 records...

I import emails from Outlook into an Access dB I want to check whether an email is a new 'thread' or 'conversation'. For example Email 1 from User: "Can you reset my password please" Email 2 from Me: "I have reset your pasword to xyz" Email 3 from User: "I tried that and it didn't work"...

When using Office 2003 I was able to import emails from an Outlook folder via the 'Get External Data' menu. This let me import into the same table each time. However on Office2007 I have been trying to import them by the following steps: External Data > More > Microsoft Outlook Folder I select...

Have devloped a database to log all support issues for an application I work with. I periodically update the database by importing from another database for example my main table tbl_issues has fields IR_NO, DESCRIPTION and STATUS I then import data from tbl_import which also has these...