Alan -
If the field in the database is [Posting Period Date], then you have the
field name wrong. Try this:
=DSum("[Amount]", "[July 09 - On Billings and Adjustments Data Query]",
"[Customer No] = '" & [cboCustomerNumber] & "' AND [Posting Period Date] = '"
& Me.[cboPostingDate].Column(0) & "'")
I am assuming cboPostingDate is a combo box, and the date you want is in the
first column. If that date is a text value in the correct format (yyyymm),
then the above should work. If not, you will need to add formatting to that.
--
Daryl S
"Alan" wrote:
Apologies Posting Date period is a text field??
"BruceM via AccessMonster.com" wrote:
Is the bound column of cboCustomerNumber a number field, and are Posting Date
Period and cboPostingDate date fields?
Alan wrote:
I have this code in a text box
= dsum("[Amount]", "[July 09 - On Billings and Adjustments Data Query]",
"[Customer No] = " & [cboCustomerNumber] & " AND Format([Posting Date
Period], ""yyyymm"") = '" & Format([cboPostingDate], "yyyymm") & "'")
i keep getting #error in my text box
i'm struggling to find they answer to why
the query July 09 - On Billings and Adjustments Data Query
has fields of
customer Number
posting periood date
Amount
Now i have two combo boxes on my form which the text box should look up
Customer number and Name, are bound to another table
No (for customer Number)
Name ( for customer Name
Customer Listing Table
not linked to July 09 - On Billings and Adjustments Data Query
Is this what causing my error and how do i fix it
Thanks in advanced
--
Message posted via http://www.accessmonster.com
.