DCount Function in VBA for two text fields and one numeric field (1 Viewer)

Jopetes

New member
Local time
Yesterday, 19:04
Joined
Sep 18, 2018
Messages
8
I have a form on input of data finds the duplicate feeding and warns. I used DCount function earlier with two text fields it was working perfectly. No I would like to add one more filed which numeric. How Do i go about it.

My fields are : Purchase_Order_Number = Text
Invoice_number = Text
Line_no = Number
 

CJ_London

Super Moderator
Staff member
Local time
Today, 03:04
Joined
Feb 19, 2013
Messages
16,612
you need to clarify your question, please provide some example data and show what you want from that example data
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:04
Joined
May 7, 2009
Messages
19,242
dcount("1", "theTable", "Purchase_Order_Number = " & chr(34) & [textString] & chr(34) & " and Invoice_number=" & chr(34) & [textInvoice] & chr(34) & " and Line_no=" & [txtLineno])
 

Users who are viewing this thread

Top Bottom