sub total only does first line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am doing something wrong. I put in a text box to display a total, but
is is displaying the total of the first line of date.... So Jim had a service
on 10/01/04 and 10/04/04 for 1 hour each. It shows one field that adds the
minutes and I want to take those minutes and convert it to the total hours
for the patient.... I have my query with a new column that divides the
minutes column by 60, but I get lost when I try to sub total my report that
is already grouped by client... Where am I going wrong... and I don't mind
rebuilding my queries and reports... I have really only one db and have
exported from Excel, so it would not be a big hardship. Thanks for your help
 
Where did you put the text box? What is the control source of the text box?
Are you attempting to total a date/time field? When you open the query in
datasheet view, is the column left or right aligned?
 
actually I figured it out... thanks... now I just need to know how to only
display > 9 hours from the totaled hours...
 
Do you just want to display the number of hours beyond 9 hours or just the
total values that add up to more than 9 hours?
 
I want to show everything in my report (detail and all) when the sum of the
total (for each person) is 9 hours or greater.... clear as mud, right?
 
How about you just type in some records and note which ones should not
show...?
 
Back
Top