Thanks for all of the help yesterday guys. I have the tour dates section working except for one thing. I have a start date field and an end date field in an access db for my friends tour dates. For example if he is playing a certain venue from the 4th to the 8th on a given month. What I am trying to do is display the next tour date on a page. The problem lies if the date lies between on of the ranges of the venue for examples on the 6th. I have tried using a for .. next loop to loop from the first date too the last date. This would work but I do not know how to compare the values the loop returns to the current day and get the one that is closest to the current date. Any help or guidance would be appreciated.