Then I would suggest that something in your logic is not what you are trying
to achieve.
What result do you get with this?
DMax("[OrderID]", "Orders", "[Transaction Type] = 2")
And what result do you see as the top record for this query?
SELECT * FROM Orders
ORDER BY OrderID DESC;
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"plisvb via AccessMonster.com" u55912@uwe wrote in message
news:9ec9b42827e6b@uwe...
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