Hey, again I grace you guys with another question.
I've run into another speed bump - REPORTING! I didn't create the database - just simply adapting it to the needs. It was created externally.
Since Access allows only a certain number of fields per report, I divided the reports into 6 separate reports. However, these are all based on one record (a program provided to clients). The database isn't normalized at all and I've asked if I could do that but he'd rather just get it up and running for the pilot run).
I want to create a form that allows the user to select the program from a drop down list and preview the combined the reports for that program. For example if I select Program A, then all 6 reports will be merged into one for that program (don't know if thats possible in Access). It should also have a preview all where you can preview all the reports for hte program the same way. They should also be able to print it! LASTLY, extract to word.. :|
I HAVE NO IDEA WHERE TO START!!!!! Someone guide me lol
I'm not sure if i should start!!
I was thinking this would involve a macro, but I don't see how a macro could do such a thing without some VBA. Then again, I don't even see Access being able to merge reports. Maybe you guys have alternate suggestions. There are approximately, 70 fields I'm reporting on all being handed as a package to over 50 program managers.