calulating totals by date range

[vposey_52]

I am having a bit of a time with creating a report. I need to create a report that does totals by a range of dates. Here^s what I^m trying to do. I want to create a report that takes an employees piece work and total it by day. This report will be over a five day__period but I don^t want to hard code dates. The data will be coming from Clippership (a shipping program). Example:____Employee Date packages shipped__user1 04/01/04 200__user2 04/01/04 180__user1 04/02/04 197__user2 04/02/04 201____I think the best way to handle this is to create the date by subtracting from the system date but the user manual was of little help. Any suggestions?

[kfleming]

Can you just set up a query for the date range?__If you want to see records for today and the previous 4 days you can create two calculated fields.__The expression for END would be DATE() and for START it would be DATE()-4____Then in the query you include all records where DATESHIPPED is greater than or equal to START and DATESHIPPED is less than or equal to date.____You then sort your records by dateshipped then employee and create a sum of packages shipped that resets by employee and place it on an employee group footer.____Kathleen__R&R Support____