#name error text box

A

Alan

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

Keeps returning #Name error

PLEASE HELP
 
R

Rose B

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
 

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

#error in text box 3
#ERROR in textbox 21
combo box look up text box error 1
Combo look up, format from number to text field 8
#Error Textbox 3
Can some tell me where my formula is going wrong please 6
can someone tell me where my formula going wrong V2 2
sum combo box based on other combo box 2

Top