Thanks,
I think it's the right data type because the following code works perfectly
on it's own textbox
=DCount("[OrderID]","Orders","[Transaction Type]=2")
Ken Snell wrote:
Your code appears to be syntactically correct, assuming that [Transaction
Type] field is numeric data type.
Hi Guys,
[quoted text clipped - 20 lines]
Thanks in advance
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1