A max select query

  • Thread starter Thread starter msmuzila
  • Start date Start date
M

msmuzila

have a query taking info from the Disk table:

Software ID
Disk ID
Disk #
Key

Software ID has a parameter from a list box on a form and I want the
query to display only the maximum Disk #.
 
have a query taking info from the Disk table:

Software ID
Disk ID
Disk #
Key

Software ID has a parameter from a list box on a form and I want the
query to display only the maximum Disk #.
Click to expand...
select Max([Disk #])
from table

??????????

hth
PerL
 
Back
Top