max value

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

Guest

I have a query right now where one of the fields is a number field and is counting the number of books total on a shelf. ( ie 1,2,3,4,....28) I would like a way to be able to find out the max value of the field ( in this case 28) so that I can compare it to the number of books that can fit on the shelf ( 30) to determine whether or not the shelf is ful
I tired using the max function in the totals but this did not give me the right result. How can I fix this error?
 
Posting the query and the wrong result could save a lot of
guess work
-----Original Message-----
I have a query right now where one of the fields is a
Click to expand...
number field and is counting the number of books total on
a shelf. ( ie 1,2,3,4,....28) I would like a way to be
able to find out the max value of the field ( in this case
28) so that I can compare it to the number of books that
can fit on the shelf ( 30) to determine whether or not the
shelf is full
I tired using the max function in the totals but this did
Click to expand...
not give me the right result. How can I fix this error?
 
Back
Top