G
Guest
You might try making a totals query based on Loan Table.
Group by student name, group by book number, and count by
book number. This will tell you how many times each
student has borrowed a book. If you include this query in
your loan query, you should be able to see how many times
the student has borrowed the book already.
Hope this helps.
Group by student name, group by book number, and count by
book number. This will tell you how many times each
student has borrowed a book. If you include this query in
your loan query, you should be able to see how many times
the student has borrowed the book already.
Hope this helps.