What put the bang! in my subquery

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Evi - 24 Apr 2008 23:35 GMT

Playing around with Subqueries I've noticed that whenever I do anything to
change the query in the Design view, a bang (!) appears just in front of the
brackets that section off the subquery. Then I get an error about the ! when
I try to run the query

Is this normal? What does it mean? What can I do to avoid it?
Evi

Reply to this Message

John W. Vinson - 25 Apr 2008 03:47 GMT

>Playing around with Subqueries I've noticed that whenever I do anything to
>change the query in the Design view, a bang (!) appears just in front of the
[quoted text clipped - 3 lines]
>Is this normal? What does it mean? What can I do to avoid it?
>Evi

Not normal at all... I've never seen it happen! What version of Access? Could
you post the SQL of such a query and indicate what kind of change you're
making?

Signature

John W. Vinson [MVP]

Reply to this Message

Evi - 25 Apr 2008 08:30 GMT

I think I know what's causing it. The bang appeared just after the word
Price in the first row and, as you can see, I didn't have a comma after it.
Since I have commas after everything else, I guess I ought to have one there
also.
I'm using Acc 2000. It appeared first when I added Item to the query's
record source (QryRptInvOrd) and then to the query.
It next appeared when I added the Order By clause.

SELECT QryRptInvOrd.InvDate, QryRptInvOrd.ItemID, QryRptInvOrd.Price(SELECT
TOP 1 Dupe.InvDate
FROM QryRptInvOrd AS Dupe
WHERE Dupe.ItemID = QryRptInvOrd.ItemID
AND Dupe.InvDate<QryRptInvOrd.InvDate
ORDER BY Dupe.InvDate DESC, Dupe.InvDate) AS PriorValue, QryRptInvOrd.Item
FROM QryRptInvOrd
ORDER BY QryRptInvOrd.Item;

Evi

> >Playing around with Subqueries I've noticed that whenever I do anything to
> >change the query in the Design view, a bang (!) appears just in front of the
[quoted text clipped - 10 lines]
>
> John W. Vinson [MVP]

Reply to this Message