G
GD
I'm getting a "The expression you entered contains invalid syntax. You may
have entered an operand without an operator." error message when attempting
the expression:
=DSum("[DiscAmt]","011_DiscTaken_t","[CheckNo]='" &
Forms![008ListCodeUEDs_frm002]!CheckNo & "' And [DCNo]=295 And
(DLookUp("[Days]","012_Terms_t","[Terms]='" &
(DLookUp("[Terms]","011_DiscTaken_t","[CheckNo]='" &
Forms![008ListCodeUEDs_frm002]!CheckNo & "'") &
"'")))<([011_DiscTaken_t!DatePaid]-[011_DiscTaken_t!InvDate])")
Datatypes:
Currency: DiscAmt
Text: CheckNo, Days, Terms
Number: DCNo
Date: DatePaid, InvDate
Can anyone help me fix the syntax?
have entered an operand without an operator." error message when attempting
the expression:
=DSum("[DiscAmt]","011_DiscTaken_t","[CheckNo]='" &
Forms![008ListCodeUEDs_frm002]!CheckNo & "' And [DCNo]=295 And
(DLookUp("[Days]","012_Terms_t","[Terms]='" &
(DLookUp("[Terms]","011_DiscTaken_t","[CheckNo]='" &
Forms![008ListCodeUEDs_frm002]!CheckNo & "'") &
"'")))<([011_DiscTaken_t!DatePaid]-[011_DiscTaken_t!InvDate])")
Datatypes:
Currency: DiscAmt
Text: CheckNo, Days, Terms
Number: DCNo
Date: DatePaid, InvDate
Can anyone help me fix the syntax?