Finding a Max value across multiple fields

[Ken P]

I've created a crosstab query that performs a count of items across a weeks
worth of dates, with the dates being the column portion of the crosstab.
Using a second query referencing the crosstab, I'm trying to extract the
biggest count for each item throughout the week. The date of the biggest
count is unimportant, only the Max number as a new value.

 

[KARL DEWEY]

Use a totals query on your raw data and not in the crosstab output.
If need more then post the crosstab query SQL.

 

[Dale Fye]

I think your best bet is along the line that Karl discussed. But Allen
Browne has a function MaxOfList( ) on his website which will do what you
want, as long as you know the name of the fields that you want to pass to the
function).

http://www.allenbrowne.com/func-09.html

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.