=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null
and pg_pedido= " & me!pedido)
The above assumes that pg_pedido is formatted as a number. If formatted as
text,
=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null
and pg_pedido= '" & me!pedido & "'")
Both examples assume that you're using this from VBA code. If you are using
it as a control source of a control on a form or report, then delete the me!
from the last part for each.
--
Ken Snell
<MS ACCESS MVP>
Frank Dulk said:
and that?
=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is
null" and pg_pedido= me!pedido)
Ken Snell said:
=DSum("[pg_valorapagar]";"[QryResumoPagamento]";"[pg_datapagamento] is
null")
--
Ken Snell
<MS ACCESS MVP>
Frank Dulk said:
Am I placing that expression in the origin of a control the because
not
this
working?
=DSum([pg_valorapagar];[QryResumoPagamento];[pg_datapagamento] is null)
