• You will find that the WeekDay() function is your friend in this case. Do a search and you will find information on how to use it. Basically it returns the day of the week as a number from 1 to 7 and using it in conjunction with the Date() function (which gives you the current date based on your PC clock), you can determine the current day of the week. You then add and subtract the amount required to get to 7 for the two Saturdays to complete your BETWEEN statement.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!