Query between dates

[jopi]

Name: Query between dates.png  Views: 16  Size: 281.6 KB  ID: 17887" class="thumbnail" style="float:CONFIG" />
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