[MS_AccessPros] DLookup question with 0

 

I have a dlookup to a query and the value is null. Here is my expression. I would like to have the result to be 0 if there is no value. right now I see #Error. Can someone give me some direction.

Thank You

=DLookUp("[CountOfDeptid2]","qry_CountOfVacantByDept","[Deptid2] = 'D0834")

 

Jim Wagner

---

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___