Using multiple parameter queries in a report

[ChipMan]

I need to use a report to show two date ranges when I use <br>2 queries that each request a date range the first range i requested once but the second must be entered for each line becasue access is using multiple queries. My Data base has 77 employee records entered each week and will have years of <br>employee records in it to enter a date for every line is impossible is there a quicker solution.

 

[DougP]

Not sur ewhat your are after here.<br>Do you want this:<br>between [Enter first date] and [Enter Second Date]<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[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 promted for the second date range it needs you to enter the range for each row in the report. The Idea behind the database is to create a simple way to print out comparisons of differnet weeks and years for each salesman in the company so that we can decide if they will get bonuses and raises and to make sure that employees are being prosuctive these reports will be printed out on demand and sent to regional sales managers as a method to review employee performance. If this workes I will have a from with two queries that prompts for employee number and 2 date 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.

 

[elizabeth]

Have you checked the FAQ page (click &quot;Back&quot; button on your browser and select FAQ tab at top of page). There is a step-by-step solution to this type of problem in the Queries category.