Creating a complex set of report

[Aterlatus]

Hi all. First of all, I'll start by saying that I'm not looking for a click-by-click rundown here, more a rough overview. I'm quite new to the world of access (although not database programming in general), so I'm just not sure where to start on this one. Once I get stuck in I should be OK

Anyway, basically I have a database that stores jobs. Each job is given a "score" for how well it was completed. Also, each job has a contractor, and an engineer belonging to that contractor associated to it. What I want to do is have a form with a few buttons on, where I can:

Click the first button to print a summary for each engineer, including all jobs they completed and their average scores.

Click the second button to print a summary for each contractor, summarising each engineer working for that contractor.

Click the third button to print an overall summary where I can compare contractors.


So, basially, what features am I going to have to look into with access to make this work? Do I need to go as far as basic programming (I'm already familiar with VB, been using it for years, so that shouldn't be a problem if necessary) or is there a simpler way to acheive my goal?

Thanks,

Steve Sherlock

 

[OnTheFly]

First you need to create the reports that you want to print. From what you said, it sounds like you are not filtering the data but printing everything every time. That certainly makes it easier.

To print a report you can attach the following command to the on click of the button

DoCmd.OpenReport...

As with VB, VBA gives you the helpful prompts as to what to enter as parameters.

Hope this helps.

Amy