For each of the documents in my report which comes from a query, HX Documents, Prospective Documents, External Documents...I want to do a count function. I am looking to find the total of records that have data added for each one. (some records will not have data under a field like Prospective Documents but data(date & time) in the other two). Then, I need the count for all that are over 24 hours. This is for each of the 3 types of documents.
My query supresses or hides all data(date & time) that is under 24 hours. That is why I need to also count all data under 24 hours also.
I may need to get the total count of documents in certain field with "data" from the Documents table and the total count documents over 24 hours from the query.
After that I want to divide the 2 totals for that document and find a percentage.
Does anyone have any suggestions?
For example
Table Query result
Appt. Date HX Documents HX > 24hrs time
12/05/05 1:00PM 12/05/05 5:00PM 0d 4hr 0min
12/05/05 1:00PM 12/06/05 3:15PM 1d 2hr 15min
12/05/05 2:00PM 12/07/05 3:30PM 2d 1hr 30min
The total would be: 3 2
Percentage: 67%
Each of the documents has a column like above. HX documents, Prospective documents, and External Documents. They are all in the same table then each has its own column(field in the query as shown above)
I hope this is clear enough.
Here is a sample of the table with data entered or not entered to clarify that part from my explanation above:
Number Appt.Date/Time HX Docs Prosp.Docs
1 12/5/05 1:15pm 12/6/05 6:30PM this one blank
2 12/5/05 2:00pm 12/6/05 6:35pm 12/6/05 6:45pm
ExternalDocs
12/6/05 10:15am
12/6/05 6:37pm
My query supresses or hides all data(date & time) that is under 24 hours. That is why I need to also count all data under 24 hours also.
I may need to get the total count of documents in certain field with "data" from the Documents table and the total count documents over 24 hours from the query.
After that I want to divide the 2 totals for that document and find a percentage.
Does anyone have any suggestions?
For example
Table Query result
Appt. Date HX Documents HX > 24hrs time
12/05/05 1:00PM 12/05/05 5:00PM 0d 4hr 0min
12/05/05 1:00PM 12/06/05 3:15PM 1d 2hr 15min
12/05/05 2:00PM 12/07/05 3:30PM 2d 1hr 30min
The total would be: 3 2
Percentage: 67%
Each of the documents has a column like above. HX documents, Prospective documents, and External Documents. They are all in the same table then each has its own column(field in the query as shown above)
I hope this is clear enough.
Here is a sample of the table with data entered or not entered to clarify that part from my explanation above:
Number Appt.Date/Time HX Docs Prosp.Docs
1 12/5/05 1:15pm 12/6/05 6:30PM this one blank
2 12/5/05 2:00pm 12/6/05 6:35pm 12/6/05 6:45pm
ExternalDocs
12/6/05 10:15am
12/6/05 6:37pm
