You need to add a WHERE clause to your query so it pulls only the desired
records for the specified valuation year. Rather than write this for you, I
think it better that you review this database programming primer first so you
have a better idea of how ADODB works as well as how to work with it.

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion