Thanks, a macro never occured to me. Doh!

im doing the new horizons mcsd course at the moment in brissie its quite fun :) bryce --- To paraphrase Fred Dagg - the views expressed in this post are bloody good ones. -- Publitor, making Pubmed easy. http://www.sohocode.com/publitor Our kids books :The Snot Goblin, and Book 2 - the Snotgoblin and Fluff

Here is a site of a game programming engine www.garagegames.com Alberto Bar-Noy VP R&D http://www.newreign.com

pjvander wrote: I need to be able to run a report/query/whatever that only selects records of a certain date range based on the Date column in said DB. I managed to run the reports I need via the Wizard, but still need to be able to filter based on that date. The syntax of the report designer is foregin to me (wish I could just use SQL!). If you want the filter at the report level, just add the following to the "Filter" property of the report. ColumnDate Between [StartDate] and [EndDate] Be sure to set the value of "Filter On" to Yes As the other poster indicated the "Filter" is really a simple where clause. I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

Thanks for the quick response. I came across this KB article that will hopefully point me in the correct direction: http://support.microsoft.com/kb/893388/en-us[^] Hopefully this will help others seeking similar solutions. Rock on CodeProject! :cool: