Number Query help

C

Chris H

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
 
M

MGFoster

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.
 
Top