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

We cannot see the data in your tables. We've told you that the logic for
your expression is correct. Therefore, I must assume that your data are not
what you think they are. We are asking for your help in telling us specific
details about your data so that we can help you debug your problem.

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;

And what result do you see as the top record for this query?
SELECT * FROM Orders
WHERE [Transaction Type] = 2
ORDER BY OrderID DESC;

--

Ken Snell
http://www.accessmvp.com/KDSnell/



"plisvb via AccessMonster.com" u55912@uwe wrote in message
news:9eca9e83e49f5@uwe...
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