Multiple queries in a report continued

[ChipMan]

I have a report that uses 2 queries with the parameter you entered so that in the report there is one column with<br>all Gross sales from any date range you pick and then another column with gross sales from a date range you pick<br>Because i used 2 queries in the report access takes the first date range and applys it to each row than when you are<br>prompted for the second date range it needs you to enter the range for each row in the report. The Idea behind the<br>database is to create a simple way to print out comparisons of differnet weeks and years for each salesman in the<br>company so that we can decide if they will get bonuses and raises and to make sure that employees are being<br>prosuctive these reports will be printed out on demand and sent to regional sales managers as a method to review<br><br>The last person who answered by problem did not solve it I need a report not a form!<br>employee performance. If this workes I will have a from with two queries that prompts for employee number and 2 date<br>ranges and allows a report to be printed out for any employee that compares yearly perfomance to the past week or any range that is requested.

 

[JeremyG]

Could you bring it all into one query then use the <br><br>&quot;Between [Enter STart Date] and [Enter End Date]&quot;as parameters for the date field?<br><br>Then base your report off the query. Am I understanding your question right ?.<br><br>Or you can make a form that they fill in the start date and end date. The queries then read the values off the form whene the report is opened per a button on the form.

 

[katiekat]

Does this need to be able to be done by a whole bunch of people? Or are you going to be the one running the report every time? If it's just you, might consider just changing the criteria on the underlying query, running it, and then running the report. It would be much easier this way, I believe. BUT! If you need to make is so any user can run it, there is a great help file in access that will take you through it step by step. I think what you put in the answer wizard guy thing is like &quot;prompts for parameters&quot; or something. Check it out. Also, maybe you want to make a crosstab query to base this report on, I don't know if that's what you used or not, there are also acutally helpful help files in access for that too!&nbsp;&nbsp;.....Good luck! =)