By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Why won't Access Run this Query?

P: n/a
UPDATE GIS_EVENTS_TEMP SET GIS_EVENTS_TEMP.FSTHARM1 =
HarmfulEvent.HarmfulEvent
WHERE (((HarmfulEvent.UnitId)=1) AND ((HarmfulEvent.ListOrder)=0) AND
((GIS_EVENTS_TEMP.CASEID)=[harmfulevent].[crashnumber])),

GIS_EVENTS_TEMP.FSTHARM1 = HarmfulEvent.HarmfulEvent
WHERE (((HarmfulEvent.UnitId)=2) AND ((HarmfulEvent.ListOrder)=1) AND
((GIS_EVENTS_TEMP.CASEID)=[harmfulevent].[crashnumber]));

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
is there a reason you have two WHERE clauses in your update? Normally
you just AND them together...

Nov 13 '05 #2

P: n/a
Yes.... Because they are different where clauses. I have a SQL server
Query that is about 80 of these

Nov 13 '05 #3

P: n/a
This same message has been posted to other newsgroups.
Nov 13 '05 #4

P: n/a
Well, have a look at the screen that comes up when you open the
software. This is NOT SQL Server. It's ACCESS. They're DIFFERENT.
Just because it works on SQL Server doesn't mean it works in Access.
Try doing a CAST in Access...

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.