I have built an income statement for my company which allows the user to put in two sets of dates (example 4/1/06-4/30/06 and 4/1/07-4/30/07) which then displays the profit/loss by chart number and compares the first date to the second. in the above example, access would return a year over year comparison for April 06 and April 07.
I have built a macro so that the user can click on it, enter the 1st set of dates, wait for that query to finish, enter the 2nd set of dates and eventually they will get their report.
Is there a way to display the date entries all at once at the beginning of the macro instead of at the beginning of each query? FYI the 1st query is a Make Table query and the second query appends data to that table. For the dates I am putting in the criteria box of each query Between [1stdate] and [last date]. I think forms may help with this but I don't know how to start.
Thanks
I have built a macro so that the user can click on it, enter the 1st set of dates, wait for that query to finish, enter the 2nd set of dates and eventually they will get their report.
Is there a way to display the date entries all at once at the beginning of the macro instead of at the beginning of each query? FYI the 1st query is a Make Table query and the second query appends data to that table. For the dates I am putting in the criteria box of each query Between [1stdate] and [last date]. I think forms may help with this but I don't know how to start.
Thanks