Dan: So you don't put the parenthesis around the whole thing? I have run into situations where I get syntax errors (not all the time) if you leave them out, so for years I have changed my ways and always put them in.
Karen In a message dated 7/30/2012 9:46:11 AM Central Daylight Time, [email protected] writes: > I do not know if this will make a difference but remove the extra () from > the max. > > SELECT MAX(OppActivityID) INTO pvOppActivityID FROM OppActivity + > WHERE OppID = .pvOppID AND OppActivityID <>.pvOppActID > > Dan > > > >
