Which the mistake?

F

Frank Dulk

=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is
null" and pg_pedido= me!pedido)
 
W

Wayne Morgan

=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null
And pg_pedido=" & pedido)

or, if pedido is text

=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null
And pg_pedido='" & pedido & "'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum 4
#Error 3
Problema con Aplicacion Pedidos 0
numeração automatica no excel 2003 0
Campo autonumerador 5
dsum syntax 2
Dsum and Dmax with structured references 1
Combobox - Problem on AddItem 11

Top