Recent content by linp

Thank you for your responses , right now i am very busy ;as soon as i get some spare time i'll try to prepare a sample db to post. Cheers ,Lin

This is way over my head !it is not that important though ,i have another query with just the arrival and departure dates ,i just wodered if it could be done easily. thanks for helping out. lin

I am actually groupng by date, like the first link ,what i want ,if possible , is format the first dog occurance Lin

thank you for your reply, if i use this method i get this: http://farm3.static.flickr.com/2162/2354917950_a1012295ee_o.jpg But what i want is this : http://farm4.static.flickr.com/3227/2354923636_4bca5c2670_o.jpg

I have a report based on a query, it is a column with a list of dates and a column with names ,these are occupancy dates . is it possible to put conditional formatting on the first occurance of a name in the list so i can see at a glance when a dog arrives ? 1-1-08 mutt 2-1-08 mutt 2-1-08...

Thank you for pointing me to the obvious ! , i completely missed the little navigation thingy at the bottom ,problem solved. cheers ,Lin

If there is ,i couldn't find it :confused:

not with 2007 , see here : http://farm3.static.flickr.com/2289/2352159793_042f91155f_o.jpg

Using Acccess 2007 ,i have a report with a list of dates with reservations ,30 pages ,i sometimes want to print not all pages ,say i want to print from march to july , i have no idea which pages to print ,print preview only shows 12 pages. Is there a way to view all pages ? I know i can filter...

Great , this is exactly what i want ! Would it be possible to get the dates " filled in " between arrival and departure ,so i will be able to view a table more like a " planning agenda ?like this but simpler , just a table .http://kennellink.com/sites/demo/code/onsiteReport.asp Thanks for your...

Thanks for your reply ,actually , we don't use kennels at all , all dogs can roam freely in and out the house and the grounds Lin

Thank you for your reply ,could you point me as to how i could use this code ? do i put it in a macro or make a query with this code ? Thanks

I am using access 2007, limited knowledge of db design. we run a dog boarding facility , in house , no kennels ; i have set up a simple db to start with ;a table with "name owner " "name dog " " arrival date " " departure date ", i can't figure out how to get the dates " filled in " between...