1. How do I carry over the [Table1]![Daily_Rate] for the calculation currently Query2 prompts me for Table1!Daily_Rate
2. How do I turn off the message "You are about to run an update query that will modify the data in your table." for everyone that runs this query... Do I have to go into Tool/Options and uncheck that on each machine or is there a way to do it from the macro?
3. How do I prevent the being prompted for the billing_date twice?