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