Dcount Multiple Criteria Syntax (1 Viewer)

[Drand]

Hi

Could someone please help me with this. I have tried so many variations with syntax and just cannot get it right!

My stripped down Dcount statement looks like:

RecordExists = Dcount("ID","tblStockOut",StockItem = & StockItem & and Quantity = & Quantity & and Date = & ThisDate &)

Where all three are variables.

StockItem is a string
Quantity is an Integer
Date is a date

Would appreciate if someone could show me exactly where all the punctuation etc. goes in this.

Many Thanks
David

 

[arnelgp]

try:

RecordExists = Dcount("ID", "tblStockOut" ,"StockItem = '" & StockItem & "' and Quantity = " & Quantity & " and [Date] = " & Format(ThisDate, "\#mm\/dd\/yyyy\#" ))

 

[Drand]

Thank you. Works perfectly.

I have googled this many times without success.

Is there a reference point where I can learn this?

 

[Gasman]

Strings need to be surrounded by single quotes ' unless it contains a single quote, then triple double quotes works, I think?

Date literals with # and in mm/dd/yyyy or yyyy-mm-dd format

Numbers do not need anything

Also for anything other than one item of criteria, I tend to put the the criteria into a string variable and then debug.print it, until correct then also use that in the function.

Added benefit is, if you still cannot see the error, you can copy and paste back here for someone else to spot it.