Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

Problem with Query data in report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bart Swisher - 04 Jan 2006 21:55 GMT
I have a database I am building that is for a police department. On the
report I need it to display the following information:
Date of Incident, Offense discription, Narrative, Offender/s, victim/s,
etc.
The problem I am having is that when I run my report, if I have more
than one offender listed and no victim, it displays the offender info
correctly. If I have more than one offender and victim it seperates the
data and displays 2 reports each with only a single offender and victim
on it.. How can I get it to list like this:

Offense---------------Date---------------Report Number(Report Number
header)
Offender(Offender Header)
Offernder1
Offender2
Victim(Victim Header)
Victim1
Victim2
Narrative(Detail)
Red - 04 Jan 2006 22:14 GMT
How is/are your table(s) setup?

This is just a suggestion..... normalize your tables, then try again =)
(No offense meant.... lord knows I'm horrible at normalizing tables
until I really really hafta ;) )

I would do like this:
Table: Offenders
OffenderID  - Number (make your own, or use some sort of ID)
OffenderLName - Offender Last Name
OffenderFName - Offender First Name

Table:  Victims
VictimID  - Number (make your own, or use some sort of ID)
VictimLName - Offender Last Name
VictimFName - Offender First Name

Table: Incidents
IncidentID - Number (make your own, or use some sort of ID)
IncidentDate - (Duh)
IncidentNarrative - Details of what happened?

Table: IncidentDetails
IncidentID
OffenderID
VictimID

Then you can make much easier reports, and your information is easier
to search and sort =)

~Red
Bart Swisher - 04 Jan 2006 22:19 GMT
No offense taken.. That is exacty how I have my tables setup. What is
happening on the report at the moment is.

Offender1
Victim1
Victim2
Offender2

The report grouping is setup with a report number header, a offenderID
header, and a VictimID header.. I have the victims grouping together
but the offenders seperate for some reason. I have both groupings
identical and both are set to can grow= yes.

I am stumped
Bart Swisher - 04 Jan 2006 22:22 GMT
No offense taken.. That is exacty how I have my tables setup. What is
happening on the report at the moment is.

Offender1
Victim1
Victim2
Offender2

The report grouping is setup with a report number header, a offenderID
header, and a VictimID header.. I have the victims grouping together
but the offenders seperate for some reason. I have both groupings
identical and both are set to can grow= yes.

I am stumped
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.