Report Problem

[rednecken15]

I’m using Access 2007 i am creating a small database for a sheriff’s department so that they can log phone calls as they receive them. The Database has a simple form displaying things like call time, caller name, info taken from call ect. My problem is i need to make a report that will print at the end of a shift that has record in one report but separated in the report also. Say they only have 3 calls during there shift i need a report that will take those three records and put them into one report but all be separate.

For example the way I don’t want it to look.

Name Date Time
John 10-10-11 8:30 am
Chris 10-10-11 9:45 am
april 10-10-11 1:45 pm

and the way i want it to look

Name: John
Date: 10-10-11
Time 8:30 am

Name:Chris
Date: 10-10-11
Time 9:45 am

Name: April
Date: 10-10-11
Time 1:45 pm

 

[Alansidman]

This should help you

http://www.datapigtechnologies.com/flashfiles/groupinginaccessrpts.html

 

[rednecken15]

Thanks man that was exactly what i needed however i now have another problem that just came up. When i run my query and then try to sort it by shift id does nothing even though it worked in the past as a matter of fact I can’t sort it at all on any given field. I double checked and made sure i cleared all my filters.

 

[vbaInet]

It doesn't do anything or it doesn't sort in the right order?

Did you apply a sort in a field before the Shift ID field?

 

[CBrighton]

And is it the order on the report or in the query? Because reports have their own sorting which overrides the query sorting.