#name error text box

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

=DSum("[Amount]","[Billings Database Hard]","[Customer No] = '" & [cbCusNum]
& "' AND [Posting Period Date] = '" & [Me].[cbPostingDate].[Column](0) & "'")

Keeps returning #Name error

PLEASE HELP
 
You need to format the date field...... try

Format(CDate(Me.cbPostingDate), "\#mm\/dd\/yyyy\#")

You shouldn't need the column as 0 is the default. Probably don't need the
single quotes around AND [Posting Period Date] = either
 
Back
Top