Dsum

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

Am I placing that expression in the origin of a control the because not this
working?

=DSum([pg_valorapagar];[QryResumoPagamento];[pg_datapagamento] is null)
 
Thank you

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)
Click to expand...
Click to expand...
 
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)
Click to expand...
Click to expand...
 
=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
Click to expand...
not
this
working?

=DSum([pg_valorapagar];[QryResumoPagamento];[pg_datapagamento] is null)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top