Recent content by gasbored

Thanks, that sounds like it

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

Thanks, I had been seen some of those but had another lookk after your reply. I have got as far as creating a Delete query DELETE [Copy Of tbl_requests].* FROM [Copy Of tbl_requests] INNER JOIN qryUniqueDateOpened ON [Copy Of tbl_requests].date_opened=qryUniqueDateOpened.date_opened WHERE...

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

Thanks. Really I want to be able to record the chain of emails below as one issue. WIll try and work out another way to do it

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

Thanks for your time and sorry for wasting it I did a search and found the phrase "I also want a query to record a count of zero" in FG's post. This, I found useful, because I wanted a query to record a count of zero ! If Brianwarnock would condescend to remember when (s)he was less...

here are my exact queries Thanks for your reply, BW First I run this query called support_stats_for_monthly_report SELECT report_category, count(*) AS instances FROM ISSUES_BY_SYSTEM_AREA GROUP BY report_category; This is the query called ISSUES_BY_SYSTEM_AREA SELECT tbl_requests.request_id...

I have the same query. Any ideas Please? I also want a query to record a count of zero, for example my monthly report query reads something like: Select system_area, count(*) from tbl_support_issues Result should be something like: Downtime (Planned ) 2 Downtime (unplanned) 0 Sofware releases...

Thanks Help is great but you have to choose your search criteria carefully. That's why a forum like this is so useful. Thanks again for your help

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