Update med select

try copying the SQL into a query wher it will be easier to see the problem.
I dont quite understand your WHERE. are both field sin the same table (tmpKundnummer and txtKundnummer) or is txtKundnummer maybe on a form?

If its on a form then try

sSQL = "UPDATE tblTemp SET tmpBeloppMånad = (SELECT VAL(SUM(COL.[UNIT_PRICE])) FROM [dbo_AMF_VW_COMMRAPP_INST] AS COL) WHERE tmpKundnummer = " & txtKundnummer

and if tmpKundnummer is a of type text then use

sSQL = "UPDATE tblTemp SET tmpBeloppMånad = (SELECT VAL(SUM(COL.[UNIT_PRICE])) FROM [dbo_AMF_VW_COMMRAPP_INST] AS COL) WHERE tmpKundnummer = '" & txtKundnummer & "'"

tmpKundnummer is in a form. tmpKundnummer is in the table.
When i try to execute it i get this error: Operation must use an updateble query!

Don´t know whats wrong? :-)

I have an idea what the problem is (Access).

Try altering the sub select to a dsum

If I remember correctly, Access doesnt like sub selects in UPDATE queries.

How can i put that into the update statement? This won´t work:
sSQL = "UPDATE tblTemp SET tmpBeloppMånad = DSUM("[UNIT_PRICE]", "[dbo_AMF_VW_COMMRAPP_INST]", "[CUSTOMER_NO]= '" & tmpKundnummer & "'")"

can you send me your dB?
ekspertenATsanthell.dk

change AT to @

Have you recieved the file?

no I havent receive anything.
Try
sandyATstofanet.dk
again AT = @

Sent it again :-)

Hi rickie
Either you are not using the correct email address, or you have a problem with your mail server.
Normally I have no problem receiving emails, so I'm sure the problem is at your end.
Can you upload to an FTP site?

Yes i can upload to an FTP :-)

I have received your dB :o)

Try this
sSQL = "UPDATE tblTemp SET tmpBeloppMånad = " & DSum("[UNIT_PRICE]", "[dbo_AMF_VW_COMMRAPP_INST]", "[CUSTOMER_NO]= '" & txtKundnummer & "'")

Thanks! :-) Sorry det sene svar!

thanks too