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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

selecting the right 'MAX' record 3
Query Question 2
Exclude most recent record numbers 4
extract 3 numbers from a string 0
Dcount returning no results!!! 0
Make table query: [Enter 1] AS Test 1
Creating an index in a query 8
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top