Query between dates

[jopi]

I'm building a database for a Boarding kennel, where I enter a date of entry and one of exit from the kennel.

However, when I build a query [>=1^st day in the kennel AND <=Last day in the kennel],

to know which animals are present in the kennel between certain dates, if for example the queried date is between 08/08/2014 and 21/08/2014 and the entry date is 07/08/2014 and the departure date is 22/08/2014, this animal won´t appear in the report (as 7 isn´t >=8 and 22 isn´t <= 21), although it occupies a place in the kennel between these.
How can I have a calendar between dates, which reflects truly which animals (and their dates) are in the kennel between these dates?

[orange]

See if this info from Paul (Baldyweb) is helpful.

[jopi]

Great idea (and so simple)!! Helped a lot!! Thank you very much