This is a great idea however it brings into question my entire query structure. Let me explain. I have a primary table that has individual jobs and a related table that has the activity of employees coming and going from that job. The primary table stores job information such as budgeted annual salary, cost center and other various descriptors while the secondary table stores employee name, actual annual salary, start date and end dates of employment. From these tables I developed queries which based on a fiscal year start date, would calculate budget, actual and forecast for a fiscal year with a particular start date. So, given a txtstart the queries would calculate each month using a formula which includes the dateadd function...so the txtstart is used in the individual monthly formulas.
So, given your suggestion and my approach, I'm not sure how I would do that. The particular forms that I am using takes the data from the final query and exports it into an excs el spreadsheet. The first form does it with discount rates and overhead and the other without. I'm thinking of putting a checkbox on one form that allows the user to add in the discount and overhead that way it would be coming off the same form. What do you think?
Thanks!
