Report Problem

rednecken15

New member
Local time
Today, 08:42
Joined
Oct 11, 2011
Messages
2
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
 

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.
 
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?
 
And is it the order on the report or in the query? Because reports have their own sorting which overrides the query sorting.
 

Users who are viewing this thread

Back
Top Bottom