View Single Post
  #4  
Old November 8th, 2009, 04:53 AM posted to microsoft.public.access.tablesdbdesign
Ken Snell
external usenet poster
 
Posts: 177
Default Need a little help with syntax

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