DLookUp Problem

[DS]

This DLookUp doesn't seem to be working. Does anyone know why?
Thanks
DS

=Nz(DSum([Expr1],"SalesDetailsQ",[SalesID]=Forms!SalesDetails!SalesID &
[SDTaxed]=True))

 

[DS]

This DLookUp doesn't seem to be working. Does anyone know why?
Thanks
DS

=Nz(DSum([Expr1],"SalesDetailsQ",[SalesID]=Forms!SalesDetails!SalesID &
[SDTaxed]=True))

Sorry, My minds in two places again...It DSum.
Thanks
DS

 

[Duane Hookom]

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!SalesDetails!SalesID
& " AND [SDTaxed]=True"), [value if the expression is null])

This assume SalesID is numeric.


--
Duane Hookom
MS Access MVP

This DLookUp doesn't seem to be working. Does anyone know why?
Thanks
DS

=Nz(DSum([Expr1],"SalesDetailsQ",[SalesID]=Forms!SalesDetails!SalesID &
[SDTaxed]=True))

Sorry, My minds in two places again...It DSum.
Thanks
DS

 

[DS]

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!SalesDetails!SalesID
& " AND [SDTaxed]=True"), [value if the expression is null])

This assume SalesID is numeric.

Thanks Duane, The SalesID is Numeric..... I cut and pasted the entire
phrase from =Nz(...................to is null])
but I'm getting a %Name# in the box. Any idea why?
Thanks
DS

 

[DS]

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" &
Forms!SalesDetails!SalesID & " AND [SDTaxed]=True"), [value if the
expression is null])

This assume SalesID is numeric.

Thanks Duane, The SalesID is Numeric..... I cut and pasted the entire
phrase from =Nz(...................to is null])
but I'm getting a %Name# in the box. Any idea why?
Thanks
DS

Duane,,,,Inspiration came quickly. This worked.

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!Sales!SalesID &
" AND [SDTaxed]=True"))

Thanks Duane, your help is greatly appreciated.
DS

 

[Duane Hookom]

I don't create Nz() expressions without providing the value if the first
argument is null.

--
Duane Hookom
MS Access MVP

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" &
Forms!SalesDetails!SalesID & " AND [SDTaxed]=True"), [value if the
expression is null])

This assume SalesID is numeric.

Thanks Duane, The SalesID is Numeric..... I cut and pasted the entire
phrase from =Nz(...................to is null])
but I'm getting a %Name# in the box. Any idea why?
Thanks
DS

Duane,,,,Inspiration came quickly. This worked.

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!Sales!SalesID & "
AND [SDTaxed]=True"))

Thanks Duane, your help is greatly appreciated.
DS

 

[DS]

I don't create Nz() expressions without providing the value if the first
argument is null.

Sorry Duane...I see what what you meant now....its been a long day!
Thanks
DS

 

[DS]

I don't create Nz() expressions without providing the value if the first
argument is null.

=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!Sales!SalesID & "

AND [SDTaxed]=True"),0)

This worked even better!!!!
Thanks
DS