Recent content by Oksana

"Second" maximum To find second highest value: SELECT Max([Number]) AS SecondMax FROM SomeTable WHERE [Number]<DMax("Number","SomeTable");

totals query Use totals query: First column: WeekDay: Format([OrderDate],"w") Group By Second Column: HowMany: [WeekDay] Count