Number Query help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have an access database, and I writing a query to pull some data, but
there is one field, which is a number field, I need some help with. It
usually only contains one number, but as it pertains to a version of a
report, other higher numbers may be in there. Is it possible to tell it only
to show the highest number that is in that field for each record?

Many Thanks

Chris
 
Chris said:
Hi

I have an access database, and I writing a query to pull some data, but
there is one field, which is a number field, I need some help with. It
usually only contains one number, but as it pertains to a version of a
report, other higher numbers may be in there. Is it possible to tell it only
to show the highest number that is in that field for each record?
Click to expand...

See the Access Help article on the Max() function.
 
Back
Top