View Single Post
  #5  
Old November 8th, 2009, 05:55 AM posted to microsoft.public.access.tablesdbdesign
plisvb via AccessMonster.com
external usenet poster
 
Posts: 13
Default Need a little help with syntax

I'm trying to find out the highest number (ID) that is an Outgoing Order (2)

Ken Snell wrote:
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;

Thanks,

[quoted text clipped - 12 lines]

Thanks in advance


--
Message posted via http://www.accessmonster.com