It's my first time using this site for help. I've got Access 2010
The data is sensative so can I save the database as something else and dump the tables/information but keep the form set up? It also appends from a different database in that report.
I'm not sure if I did that right but it did not work. I'll dummy up a database and copy the report and try sending it to you. I've got a meeting soon so have to go. When I'm ready will our discussion still be here so I can follow the instructions to send you the database?
Sounds good...thank you!
I've uploaded the file to wikisend and the # is 918954.
The database form MAIN is where I choose the criteria for the GeneralReport. I'd like to be able to run the report and not have the same incident pop up multiple times on the form. It does that if there is more than 1 MO and if I choose the Offense theft and under that incident there is theft, Auto theft, etc.
I hope that makes sense. I'd like to know how you fix this as I'm hoping to learn as I go with this database.
Thank you much!! Tyna
Sure! Tonight I can also try to save as an earlier version? Just let me know.
I get a message that says "cannot save database to an earlier format because it uses features that require the current file format.
I'll try anything!
I'm trying to add the incident header and and have not quite figured it out...just started. I wanted to let you know as soon as I do and it works I'm going to rate you with high marks. I just want to wait until it does work.
Sorry, I thought I sent a message yesterday. The grouping did not prevent duplicate entries from the report...it just removed the incident number.
Offense Theft Date: 1/1/13 Location: xyz
MO: scrap metal, gang involved
next line does not show the incident number but it's the same one and then lists the next offence for that incident along with the MO's.
Incident area blank (same as before)
Offense narcotics Date: 1/1/13 Location: xyz
When I run a report off MO how can I get the report to show only one entry for the incident.
Offense Theft, Narcotics Date: 1/1/13 Location: xyz
Yes...ONLY the incident is in the Incident Header.
'Details' contain everything else that goes with the incident. There are at times multiple offenses to one case number along with multiple MO's. Not sure if that matters.