Prev: Is it possible to create a form that resembles a table?
Next: Can you add a tab control inside another tab control
From: Alan on 25 Mar 2010 05:57

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







From: BruceM via AccessMonster.com on 25 Mar 2010 07:14
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

From: RonaldoOneNil on 25 Mar 2010 07:45
Because the DSum arguments are enclosed in quotes and you have quotes in your
Format statements.

"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
>
>
>
>
>
>
>
From: Alan on 25 Mar 2010 08:03
No Customer Number is a Text Field and posting Date is a Date 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
>
> .
>
From: Alan on 25 Mar 2010 08:06
I Take the quotes out like this

= dsum([Amount], [July 09 - On Billings and Adjustments Data Query],
"[Customer No] = " & [cboCustomerNumber] & " AND Format([Posting Date
Period], ""yyyymm"") = '" & Format([cboPostingDate], "yyyymm") & "'")

Then I get Name error in the text feild


"RonaldoOneNil" wrote:

> Because the DSum arguments are enclosed in quotes and you have quotes in your
> Format statements.
>
> "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
> >
> >
> >
> >
> >
> >
> >
 |  Next  |  Last
Pages: 1 2 3 4 5 6
Prev: Is it possible to create a form that resembles a table?
Next: Can you add a tab control inside another tab control