Trying to find the biggst value in a table

[sddf fgf]

Hi,

Ive got a Product table that has a productID.
This is incremented insdie the access table itself.
What im trying to do is find the biggest number in the table and output all the information in that row.

Now the biggest number keeps changing when a new product is entered. ie.
Product ID = 34 contains plugs.
if a new product is entered it will become
product id = 35 contains screws.

So how can i write a code that finds the largest by just looking into the biggest number?

[sierra7]

Hi
One way is to create a query selecting each of the fields from your Product table, then set Order By to ProductID Descending. Create a Form based on this query and the first item to be displayed will be the last one added. No code needed.

Alternatively you could use the DMax() function to find the largest ProductID. But what do you mean by 'output all the information in that row'? To where? a pop-up message window, a form or a report?

We need more info to take this further.
S7

[NeoPa]

I'm going to assume for now that you are looking for a query that returns the data you requested. If you need other information then, as S7 says, you need to provide more information in the question.

SELECT *
FROM   [Product]
WHERE  ([ProductID] = SELECT Max([ProductID])
                      FROM   [Product])

This uses a subquery to determine the max value, which is similar to using DMax() but where DMax() is a function the subquery is part of the SQL itself so can work more efficiently. Domain Aggregate functions like DMax() are of most use when used from within VBA code, although they certainly can be used within SQL too if required.