Listers,

First of all this is an Access related issue, so qualifies to be an off topic 
question I guess. I just figured many of you might be using Access as a choice 
of tool for data cleaning so may be familiar with what I am facing..

Below is the query I have written in Access, to set the name of the company in 
the table RefreshData, based on the domain of a users business email address..

While this query runs perfectly and sets the company name, if I try to save the 
query for future use in Access, it doesn't save it but crashes out Access, and 
when I reopen it, the query has nothing in the SQL panel besides the default 
SELECT; that appears when you open a new access query to build a new query..

This is the update query that I've successfully ran, but unable to save..

UPDATE RefreshData SET RefreshData.[Company] = 
IIf(RefreshData.[User Email Address] Like '*centresolutions.com',"Centre 
Solutions",
IIf(RefreshData.[User Email Address] Like '*csc.com',"Computer Sciences 
Corporation",
IIf(RefreshData.[User Email Address] Like '*farmersinsurance.com',"Farmers 
Insurance",
IIf(RefreshData.[User Email Address] Like '*foremost.com',"Foremost Insurance 
Group",
IIf(RefreshData.[User Email Address] Like '*kraftlake.com',"Kraft Lake 
Insurance Agency (KLIA)",
IIf(RefreshData.[User Email Address] Like '*us.ibm.com',"IBM - United States",
IIf(RefreshData.[User Email Address] Like '*wipro.com',"Wipro Technologies",
IIf(RefreshData.[User Email Address] Like '*wtp.ca',"WTP",
IIf(RefreshData.[User Email Address] Like '*zurich.com',"Zurich Financial 
Services Group",
IIf(RefreshData.[User Email Address] Like '*zurichbf.com',"Zurich Benefit 
Finance",
IIf(RefreshData.[User Email Address] Like '*zurichna.com',"Zurich North 
America",RefreshData.[Company])))))))))));

Any idea why this may be happening?

As a workaround I have saved this in notepad for future use - not convenient 
but will have to do..

Joe




_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to