X
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
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