F Frank Dulk Jun 17, 2004 #1 =DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null" and pg_pedido= me!pedido)
=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is null" and pg_pedido= me!pedido)
W Wayne Morgan Jun 17, 2004 #2 =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 & "'")
=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 & "'")