This is the SELECT Statement as requested.

SELECT Animals.name, Animals.type, Breeds.breed_type, Animals.colour,;
Animals.age,;
IIF(Animals.gender=0,"",IIF(Animals.gender=1,"Male","Female")),;
Animals.size, Animals.date_in, Animals.date_out;
FROM boarder!breeds INNER JOIN boarder!animals ;
ON Breeds.breed_key = Animals.breed_key;
WHERE Animals.client_key = ?vp_client;
ORDER BY Animals.name, Animals.type