Parameter for DSum Function

  • Thread starter Thread starter Helmut
  • Start date Start date
H

Helmut

I am running an update query that uses the dsum function
with a criteria that is passed as a string in single
quotes. The criteria part of the dsum function looks like
this:
"[tblInvoiceLine].[strInvcNum]='F93481'"
This query works fine, it updates as it should.

But I need to parametrize the query, so that I can pass a
different criteria string to the dsum function each time I
run the query. I created the runtime parameter [Enter
number] and tried:
"[tblInvoiceLine].[strInvcNum]='[Enter number]'"
This does not update the fields any more (probably
evaluates the dsum to NULL).

What's the correct syntax?
 
Try:

"[tblInvoiceLine].[strInvcNum]='" & [Enter number] & "'"

HTH
Van T. Dinh
MVP (Access)
 
Back
Top