depending upon how your table is set up, why not just a crosstab query that counts all the cats on each day in the range for the reservation, giving you totals day by day - that way you have a report that tells you which days are problems, so you can offer that to cat owner to see if they can...