Group Time w/o using wizard

[rainman89]

Hi all,
Im not real good with recordsets, but i think that is what i need to accomplish this task.

i need to have a total by case number w/o using the sorting and grouping option in the report wizard, reason is i need the format to stay the same, but have the total time for each case entry to be shown on the report.

I have a total time for the day, but thats not enough for management! is there a way to do this w/o using the sorting / grouping option?

 

[phatnq2002]

You can create a total query, then use it for the report RecordSource.

 

[rainman89]

That might work, but i dont want to change the format that is already there. i know how to create a total query, but i dont knowhow to group by the case ID and still show all entries for the day.

would a subreport be a better idea? ive never created one before so im not sure that would be what i need

 

[shudini]

If you don't plan on using any grouping levels on the report, where would you want to display the totals? usually totals are displayed in the group footer, but you are saying you don't want to use any groups.

You could include in your query a DLookup to have each record return the total for that case number, but where would you display it on the report?

 

[rainman89]

i have a grouping level for date, so id have the totals in that. im just going to try to use a subreport with a diff query i have made