From Abe :
snap!
Any advice or help is welcome!
Thank You!

PS: If more clarity is needed, feel free to indicate so.

Well, one quick and simple way would be to add a field to the
tblHotelBookings indicating it is a 'combined' booking (or something
like that). Simple yes/no field would do.
Smith has this value set to No and Jones set to Yes. Then, sum up all
the fields that have this field set to no.

Another approach would be to create a query to sum the totals.
If your reservations table has fields for room (x), date (y) in and
date (z) out, you could query it and use distinct to get x, y and z
only one time. However, problems might rise when you have mister Smith
from Thursdat till Sunday and miss Smith for only Saturdaynight because
you will have to have more logic in the query. Not undoable though.

I think the first solution would be the easiest since that will show
mister Smith for 3 nights and miss Smith for 1 night. With the combined
booking field set to Yes for miss Smith and thus leaving her out of the
totals.