Hello:
I am trying to run a query that needs to look at two different time periods. the query is being run using two different queries. one keeps track of salesman refusals per account and the other gives a total amount of refusals per account YTD.
I need to include all fields in salesman refusals (which is a weekly report, weekly parameter, exmp 7/15/02 to 7/19/02) and the running total of refusals per account YTD.
The problem i'm running into is that when i put my weekly parameter the query returns a value of 1 in my YTD count. How do i get the query to give me my weekly report and at the same time give me one field with the running total/count for the year.
Thanks for your Help
I am trying to run a query that needs to look at two different time periods. the query is being run using two different queries. one keeps track of salesman refusals per account and the other gives a total amount of refusals per account YTD.
I need to include all fields in salesman refusals (which is a weekly report, weekly parameter, exmp 7/15/02 to 7/19/02) and the running total of refusals per account YTD.
The problem i'm running into is that when i put my weekly parameter the query returns a value of 1 in my YTD count. How do i get the query to give me my weekly report and at the same time give me one field with the running total/count for the year.
Thanks for your Help