booking diary

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a view which shows dates along the top, caravans along
the slide and the data showing whether their is a booking or not. Any
pointers?
 
Carolinec,
Use a Crosstab query to do that. See Help on Crosstab, and there is a wizard to assist
you.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Thanks - the cross tab is quite good. However, I have two date fields
(arrive and checkout). I'd like to show the dates in between as booked also.
Any ideas?
 
Back
Top