Grouping Dates to get information!

J

JOM

I have the following 2 dates in my table.... DateReceived, DateCompleted. An
employee receives requests daily. They will receive a rqst and enter the rqst
in the Date Received field, if its completed, they will fill the
DateCompleted Field
How do I calculate the Total rqst pending, calculate the Total Rqst
Completed regadles of when it was received etc......

I would like to create a report whereby it will look like this

Date: Total Rqst Total Rqst Total Rst
Rcvd Completed Pending

1/1/05 10 5 5
02/01/05 5 7 2
03/01/05 0 2 0
 
A

Al Camp

JOM,
Try the ReportFooter for an "overall" total of all values listed.

= Sum(TotalRqstRcvd) - Sum(TotalRqstCompleted)
will give the "overall" total.

hth
Al Camp
Candia Computer Consulting - Candia NH> employee receives requests daily.
They will receive a rqst and enter the rqst
in the Date Received field, if its completed, they will fill the
http://home.comcast.net/~cccsolutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top