1) To Append or Overwrite that is the question. This depends on whether you need to reference he older data or not. As well as how frequently you plan on backing up your database. If you have a good back system for the database then overwrite (or delete and add) coupled with a compact will keep the database smaller. If you not planning on storing a lot of data then Append is quicker and simplier.
2) To Use a Report or export to Word which is better. If you want to keep it very simple go with the Report. If you want to get to know the mechanics behind exporting to a Word document for possible other projects then I'd go that route or if you need to keep an easily viewable electronic copy of the report on file for some reason. 3) How much VBA and/or SQL would be involved. Not sure how to answer this one... my biggest problem here is I'm a VB programmer and I'd probably do nearly all of it in VBA/SQL since that would allow it to be much more portable for when this small critter eventually turns into a large monster and they need to migrate it to a SQL Server or if I want to be able to reuse code segments for other jobs later on down the road. Short Term solution the smallest amount of VBA/SQL will do the job... Long Term solution the more VBA/SQL you use the easier it is to maintain, enhance and to port. Hope that was helpful. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
