Hey there,

A coworker of mine said that he is trying to make a Report for his Church with his access database, and he wants it so that before the report is generated, it gives the user a drop down box of all the available dates, and then shows the people who gave money on those dates.

I told him I would try to find some help on a message board. Attached is what he has so far in a zip file.

Thanks! May Jesus bless your soul! :)

I went in and created a form that allows for selecting a date and then opening a report that uses that date. Also, I would highly suggest renaming some fields because words like NAME, DATE, etc. are RESERVED words in Access and using them for object names can only cause grief at some point in time.

Take a look at what I did and see if that helps.