update indeholdende select count. help plz

Not sure I understand this syntax!

([underMadOrdre].[ordreid]=@ordreid))

where does this come from @ordreid ?

Access seems to have trouble with nested SQL statements in UPDATE queries. Try altering the Nested query to a dcount for example.

UPDATE MadOrdre SET antalbestillinger = DCount("*", "[underMadOrdre]", [ordreid]=@ordreid) WHERE (MadOrdre.ordreid=[@ordreid]);

or something like that, although I still dontkno where @orderid comes from

Little error there.

UPDATE MadOrdre SET antalbestillinger = DCount("*", "[underMadOrdre]", "[ordreid]=@ordreid") WHERE (MadOrdre.ordreid=[@ordreid]);

@ordreid er en variable, det er fordi jeg ikke bruger det direkte i access men gennem en web app. men det var ligesom det mest rigtige sted at spørge om det.

Mange tak, det var lige det jeg skulle bruge.

dampnet>But is it necessary to update antalbestillinger? You can ALWAYS find antalbestillinger by selecting count from underMadOrdre just as you are doing in the sub select.
Or you can make a query in the access database which JOINS the two tables and groups on ORDERID then you can  have a column showing the count.

Then you can use this query in your web application instead of the table.

So Dcount worked ?

og selv tak

mine tabeller ser som følger ud:
| ordreid(key) | antalbestillinger(tal: underordre med dennes ordreid) |  + mere |
| underordreid(key) | ordreid(f.key)|  + mere |

det er så antalbestillinger som jeg opdatere gennem min app., siger du jeg skal kunne lave det smartere ?

antalbestillinger er = med count underordreid hvor MadOrdre.ordreid = underMadOrdre.ordreid
derfor er antalbestillinger ikke nødvendig!