Access SQL to JET SQL HELP

[Trope]

Does anyone know how I can make this work in JET SQL from an ASP page? I seem to be running into problems. And what are the exclamation points? Thanks in advance.

John

UPDATE dealertable INNER JOIN special ON dealertable.customernumber = special.customernumber SET dealertable.businessname = [special]![businessname], dealertable.contact = [special]![contact], dealertable.address1 = [special]![address1], dealertable.city = [special]![city], dealertable.state = [special]![state], dealertable.zip = [special]![Zip], dealertable.phone = [special]![phone], dealertable.latitude = [special]![latitude], dealertable.longitude = [special]![longitude]
WHERE ((([dealertable]![businessname])<>[special]![businessname])) OR ((([dealertable]![contact])<>[special]![contact])) OR ((([dealertable]![address1])<>[special]![address1])) OR ((([dealertable]![city])<>[special]![city])) OR ((([dealertable]![state])<>[special]![state])) OR ((([dealertable]![Zip])<>[special]![Zip])) OR ((([dealertable]![phone])<>[special]![phone])) OR ((([dealertable]![latitude])<>[special]![latitude])) OR ((([dealertable]![longitude])<>[special]![longitude]));

 

[THoey]

First, you say make it work. What happens when you run it? Does it error or does it just not provide the results you want?

Second, the &quot;!&quot; signifies a field in a specific table, so &quot;[dealertable]![businessname]&quot; means the &quot;businessname &quot;field of the table called &quot;dealertable&quot;. Terry M. Hoey