Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: caitliniag
- Content: Threads
- Order by date
-
Calculating a median in a query
I am writing a statistical report for a weekly reporting database and need to include the median as well as the average in the report. The SQL for the report is: SELECT vw_a.Assessor, Count(vw_a.Award) AS CountOfAward, Avg(vw_a.Award) AS AvgOfAward, Max(vw_a.Award) AS MaxOfAward...- caitliniag
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
