Help with largest values and counts of those values

J

JRV

Help! Trying to display information from a cross tab query in MS Access.
Could only get the correct information displayed by hard coding in the
following to view and check every record (250) and display the largest
number, how many instances of that number and the days those numbers fall on.
Not able to get access to recognize the data object as a value. By hard
coding this in, we have run into our limit within access and still need to
display more information. Any ideas on how to condense this and still get the
information?
 
Top