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:
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
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:
Code:
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