dsum issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a control on a form with the following formula
=DSum("[FeeAccrued1]","qry_RCTrack"," [sCliNum] = ????")

Obviously the ???? is the part I can't figure out. I'm trying to sum the
FeeAccrued1 field where the [sCliNum] field from the domain equals the
[sCliNum] field on the form AND the[MonthEnd] field in the domain equals the
[MonthEnd] field in the form.

Any help is greatly appreciated.
 
Did you mean to send this to a Report NG or Form.
Either way, you might be able to use:
=DSum("[FeeAccrued1]","qry_RCTrack", " [sCliNum] = " & [sCliNum] & " AND
[MonthEnd] =" & [MonthEnd])

The above assumes the fields are numeric. You need to add the appropriate
delimiters if not.
 
Assuming that both fields are numeric:

=DSum("[FeeAccrued1]","qry_RCTrack","[sCliNum] =" & [sCliNum] & " And
[MonthEnd]=" & [MonthEnd])
 
sorry, the sCliNum is text and MonthEnd field is date. COuld you help me out
witht hat syntax?

Ken Snell said:
Assuming that both fields are numeric:

=DSum("[FeeAccrued1]","qry_RCTrack","[sCliNum] =" & [sCliNum] & " And
[MonthEnd]=" & [MonthEnd])

--

Ken Snell
<MS ACCESS MVP>



Bdavis said:
Hello,

I have a control on a form with the following formula
=DSum("[FeeAccrued1]","qry_RCTrack"," [sCliNum] = ????")

Obviously the ???? is the part I can't figure out. I'm trying to sum the
FeeAccrued1 field where the [sCliNum] field from the domain equals the
[sCliNum] field on the form AND the[MonthEnd] field in the domain equals
the
[MonthEnd] field in the form.

Any help is greatly appreciated.
 
=DSum("[FeeAccrued1]","qry_RCTrack","[sCliNum] =""" & [sCliNum] & """ And
[MonthEnd]=#" & [MonthEnd] & "#")
--
Duane Hookom
MS Access MVP


Bdavis said:
sorry, the sCliNum is text and MonthEnd field is date. COuld you help me
out
witht hat syntax?

Ken Snell said:
Assuming that both fields are numeric:

=DSum("[FeeAccrued1]","qry_RCTrack","[sCliNum] =" & [sCliNum] & " And
[MonthEnd]=" & [MonthEnd])

--

Ken Snell
<MS ACCESS MVP>



Bdavis said:
Hello,

I have a control on a form with the following formula
=DSum("[FeeAccrued1]","qry_RCTrack"," [sCliNum] = ????")

Obviously the ???? is the part I can't figure out. I'm trying to sum
the
FeeAccrued1 field where the [sCliNum] field from the domain equals the
[sCliNum] field on the form AND the[MonthEnd] field in the domain
equals
the
[MonthEnd] field in the form.

Any help is greatly appreciated.
 
Back
Top