> I am building an account-program, for that:
> I want to update a field in an access table.
> The field should add the value in tableR.bedrag
> with the sum in tabelb.bedrag in a certain periode
> A bit like this:
> Update TableB set Bedrag = TableR.Bedrag + SUm(tableB.bedrag) where datum
> between fromdate and todate.
> where TabelR.bedrag is the value from a previous periode, written in
If we overlook that this forum/newsgroup is dead, the scope for this
newsgroup is SQL Server, and you talk about Access. I would recommend
that you find an Access forum to answer the question. While both SQL Server
and Access use SQL, there are considerable differences between the two.
Erland Sommarskog, Stockholm, esq...@sommarskog.se