Do I use "0" or 0

[hbaggs]

I wonder which is correct

If IsNull(DLookup("PrivateContractFee", "tblAllStatementTEMP")) Or (DLookup("PrivateContractFee", "tblAllStatementTEMP")) = "0" Then
objDoc.Bookmarks("PrivateContract").Select
objWRD.Selection.Rows.Delete
End If


or is it ?


If IsNull(DLookup("PrivateContractFee", "tblAllStatementTEMP")) Or (DLookup("PrivateContractFee", "tblAllStatementTEMP")) = 0 Then
objDoc.Bookmarks("PrivateContract").Select
objWRD.Selection.Rows.Delete
End If



Also is this use of OR acceptable?

 

[Bat17]

If you are just checking if it contains any records then Dcount is better

If DCount("*", "tblAllStatementTEMP") = 0 Then
   objDoc.Bookmarks("PrivateContract").Select
   objWRD.Selection.Rows.Delete
End If

If you actualy need to check for a 0 in the record as well then
If DCount("*", "tblAllStatementTEMP") = 0 Or DLookup("PrivateContractFee", "tblAllStatementTEMP") = 0 Then

You should only need to quote the 0 if PrivateContractFee is a text field HTH

Peter

 

[hbaggs]

thank you

thank you for your help

 

[Pat Hartman]

Date literals are delimited with #
#2/23/2006#
Text literals are delimited with "
"this is a text field" as is this - "2334"
Numeric literals are NOT delimited
2334

 

[hbaggs]

thank you

thank you again