November 8th, 2009, 04:55 AM
posted to microsoft.public.access.tablesdbdesign
|
|
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
|