From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05.  It also looks like it doesn't matter when they will be checking out.  Try the following query:

Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'