#Error Textbox

[Alan]

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = '" & [cboPostingDate] & "'")

Right i used this code in the source code of my textbox and the textbox
keeps flashing, i click on it an it says #ERROR

am i moving forward ?? lol

 

[Douglas J. Steele]

If Posting DatePeriod is a date field, you need to use # delimiters:

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = #" & [cboPostingDate] & "#")

In fact, you're best off using

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#))

 

[Alan]

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#))

This gives me a invalid string #error

If Posting DatePeriod is a date field, you need to use # delimiters:

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = #" & [cboPostingDate] & "#")

In fact, you're best off using

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#))

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" &
[cboCustomerNumber]
& "' AND [Posting DatePeriod] = '" & [cboPostingDate] & "'")

Right i used this code in the source code of my textbox and the textbox
keeps flashing, i click on it an it says #ERROR

am i moving forward ?? lol

.

 

[Daryl S]

Alan -

Missing a double-quote at the end of the date formatting. Try this:

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#"))

--
Daryl S

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#))

This gives me a invalid string #error

If Posting DatePeriod is a date field, you need to use # delimiters:

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = #" & [cboPostingDate] & "#")

In fact, you're best off using

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" & [cboCustomerNumber]
& "' AND [Posting DatePeriod] = " & Format([cboPostingDate],
"\#yyyy\-mm\-dd\#))

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

=DSum("[Value]","Billings Analysis","[CustomerNo] = '" &
[cboCustomerNumber]
& "' AND [Posting DatePeriod] = '" & [cboPostingDate] & "'")

Right i used this code in the source code of my textbox and the textbox
keeps flashing, i click on it an it says #ERROR

am i moving forward ?? lol

.