|
 |
access thread: DSUM() Function With More Criteria
Message #1 by "Maha Arupputhan Pappan" <mahap@p...> on Tue, 21 Jan 2003 01:16:05
|
|
Hi all, Good day.
I inserted the following in my Event Procedure.
Private Sub Quantity_AfterUpdate()
Dim Criteria1 as String, Criteria2 As String
Criteria1 = Me!GRNNo
Criteria2 = Me!StockCode
X = DSum("[Quantity]","tblReceive", "[GRNNo]= " & "'" & Criteria1 & "'")
End Sub
Question
--------
How to include Criteria2 in the DSum statement? That will lead the DSum()
function to validate the following to match each criterias:
[GRNNo] = Criteria1
[StockCode] = Criteria2
Thanks,
Maha
Message #2 by Debby <soccerlust@c...> on Mon, 20 Jan 2003 18:06:24 -0700
|
|
take me off your list
----- Original Message -----
From: "Maha Arupputhan Pappan" <mahap@p...>
To: "Access" <access@p...>
Sent: Monday, January 20, 2003 6:16 PM
Subject: [access] DSUM() Function With More Criteria
> Hi all, Good day.
>
> I inserted the following in my Event Procedure.
>
> Private Sub Quantity_AfterUpdate()
>
> Dim Criteria1 as String, Criteria2 As String
>
> Criteria1 = Me!GRNNo
> Criteria2 = Me!StockCode
>
> X = DSum("[Quantity]","tblReceive", "[GRNNo]= " & "'" & Criteria1 &
"'")
>
> End Sub
>
> Question
> --------
> How to include Criteria2 in the DSum statement? That will lead the DSum()
> function to validate the following to match each criterias:
>
> [GRNNo] = Criteria1
> [StockCode] = Criteria2
>
> Thanks,
> Maha
>
Message #3 by "Maha Arupputhan Pappan" <mahap@p...> on Wed, 22 Jan 2003 07:41:30 +0800
|
|
Hi Debby,
I don't mean to sent my question to you. I published my question via the p2p
web and I don't sent it to you personally.
I don't know how it went to your email.
Thanks,
Maha
----- Original Message -----
From: "Debby" <soccerlust@c...>
To: "Access" <access@p...>; <mahap@p...>
Sent: Tuesday, January 21, 2003 09:06
Subject: Re: [access] DSUM() Function With More Criteria
> take me off your list
>
>
> ----- Original Message -----
> From: "Maha Arupputhan Pappan" <mahap@p...>
> To: "Access" <access@p...>
> Sent: Monday, January 20, 2003 6:16 PM
> Subject: [access] DSUM() Function With More Criteria
>
>
> > Hi all, Good day.
> >
> > I inserted the following in my Event Procedure.
> >
> > Private Sub Quantity_AfterUpdate()
> >
> > Dim Criteria1 as String, Criteria2 As String
> >
> > Criteria1 = Me!GRNNo
> > Criteria2 = Me!StockCode
> >
> > X = DSum("[Quantity]","tblReceive", "[GRNNo]= " & "'" & Criteria1 &
> "'")
> >
> > End Sub
> >
> > Question
> > --------
> > How to include Criteria2 in the DSum statement? That will lead the
DSum()
> > function to validate the following to match each criterias:
> >
> > [GRNNo] = Criteria1
> > [StockCode] = Criteria2
> >
> > Thanks,
> > Maha
> >
>
>
|
|
|
View Cart
