PLEASE HELP!!!

[xGemsiex]

I am currently doing an ICT project where i have produced a booking based
system, based on a school and the system allows teachers to book out
equipment they want for the next lesson e.g. text books.

the end user wants the system to produce reports based on which teacher has
booked the most equipment and which equipment is the most popular to book.

I have designed a query for the which teacher has booked the most equipment
however, surely for me to be able to see which teacher has the most bookings,
i need to insert some kind of filter into the query or report: something like
only show the teacher that has the most records in the table. can anybody
help?! i have tried everything! thankyou, gemma

 

[John Spencer]

Take a look at the TOP predicate in a query.

SELECT TOP 1 Teacher
FROM SomeTable
GROUP BY Teacher
ORDER By Count(Teacher) Descending



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================