Search results
-
L
Help with query calculated colums and query count
I'm trying to create two queries that needs to: 1. display animal and number of animals on loan I do not know what I'm doing wrong as all regions are showing only 1 animal on loan: SELECT Animals.Animal, Count(Loans.[Animal ID]) AS [Number oF Animal On Loan] FROM Loans INNER JOIN Animals ON...