Which the mistake?

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

Frank Dulk

=DSum("[pg_valorapagar]","[QryResumoPagamento]","[pg_datapagamento] is
null" and pg_pedido= me!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 & "'")
 
You must log in or register to reply here.

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
Problem with combobox,selectedvalue 3
Combobox - Problem on AddItem 11
yes/no button confirmation 2
Dsum but £0.00 if null 3
Change to report code needed 3
DSum Countrol Source Help 5

Back
Top