Query not working correctly...

[PogoWolf]

HI! Here's the problem, on the below query SQL returns 'too few parameters' and I can't figure out why.. this Query works fine from Access2K..

SELECT SBUs.Name
FROM SBUs
INNER JOIN (DocTypes INNER JOIN DocTypeLookup ON DocTypes.AutoID = DocTypeLookup.DocType)
ON SBUs.autoID = DocTypeLookup.Owner
WHERE (((DocTypes.Name)="AGRM - Return Mail&quot); ******
Darkness... Bleakness...
and Plastic forks...
--The PogoWolf

 

[tlbroadbent]

Does the query fail in another version of Access or are you referring to another RDBMS? Terry

;-) He has the right to criticize who has the heart to help. -Abraham Lincoln

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[PogoWolf]

I was able to 'fix' part of this issue.. the " in the query needed to be a ' and that works fine... the issue that I'm having now is Oracle is giving me fits saying the query isn't being terminated correctly.. but that's for another group. =)


---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com