Impressive use of your noggin. Hopefully I can explain my problem a little better. I have changed my data import to create a date record for every night. Instead of the arrival date and number of nights. I can easily change back it this doesn't provide the results the best way. Below is some sample data. This seems like it should be so easy compared to some of the stuff I work on but I'm completely blocked.
unitCode Date mc 2006-08-11 mc 2006-08-12 mc 2006-08-13 mc 2006-08-14 mc 2006-08-15 mc 2006-08-16 mc 2006-08-17 NS19 2005-08-14 NS19 2005-08-15 NS19 2005-08-16 NS19 2005-08-17 NS19 2005-08-18 If my search dates are (2005-8-12) to (2005-08-13) the result should be just NS19. Obviously the between does not work since both have dates outside the search and therefore they both match. Is there a way to group them so if there is one matched date it does not return that property? Thank you again for any help. Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
