Search results

hey it works!! thanks right, to ask a more advanced question. supposing i had four hotels red blue green yellow each with 20 beds. how could i add up the number of customers on a particular date and produce a report showing empty beds on a certain day

i have a long list of check in dates, some from the past, some the future. same for check out i need a search to give me a list of customers presently there

for a hotel database i have check in date and check out date how do i get a list of current occupants, ie a search using todays date sorry if this is simple, but i am not great at access. i hate vb code as well