J
James McNellis
Hello,
I have a rather serious problem with a query I am trying to execute:
SELECT pbs.pbsId, pbs.pbsName, pbs.pbsPl, pbs.pbsRevisionId,
pbs.revisionName
FROM [SELECT pbsId, pbsName, pbsPl, pbsRevisionId, pbsRevisionName FROM
qPbsItems WHERE pbsRevisionId=5]. AS pbs
WHERE (SELECT COUNT(pbsWbsMap.pbsId) FROM pbsWbsMap, wbsItems WHERE
pbsWbsMap.pbsId=pbs.pbsId AND pbsWbsMap.wbsId=wbsItems.id AND
wbsItems.revisionId=3)=0;
Whenever I run the query, Access crashes with no error message (except the
"Send error report to Microsoft").
The query executes fine if I delete the top-level WHERE clause.
Does anyone have any suggestions? I've been trying to play with this for
the last two hours, and have had no success.
Thank you in advance for helping!
James.
I have a rather serious problem with a query I am trying to execute:
SELECT pbs.pbsId, pbs.pbsName, pbs.pbsPl, pbs.pbsRevisionId,
pbs.revisionName
FROM [SELECT pbsId, pbsName, pbsPl, pbsRevisionId, pbsRevisionName FROM
qPbsItems WHERE pbsRevisionId=5]. AS pbs
WHERE (SELECT COUNT(pbsWbsMap.pbsId) FROM pbsWbsMap, wbsItems WHERE
pbsWbsMap.pbsId=pbs.pbsId AND pbsWbsMap.wbsId=wbsItems.id AND
wbsItems.revisionId=3)=0;
Whenever I run the query, Access crashes with no error message (except the
"Send error report to Microsoft").
The query executes fine if I delete the top-level WHERE clause.
Does anyone have any suggestions? I've been trying to play with this for
the last two hours, and have had no success.
Thank you in advance for helping!
James.