Repetative Data

[amfroehlich]

I am a simple database with four tables, Events (which hold eventsID and Names), Invoice (which hold all the invoice information), Manufacturers(which hold manufacturer info), and Programs(which holds the different programs costs and so forth). I am trying to make a report which displays information from all of the tables, and sums the programs costs that they can be compared to Invoices Amount for the Programs. But, for some reason I can either get the programs, to come out with no sum of the costs, or I can get all the programs to come out 3 times with the correct program costs. What am I doing wrong?

Please Help!!!

 

[Joe4]

You need to establish the correct relationships between your tables. You can do this in the Relationship window, or right in the query itself. See "Define relationships between tables" in Access Help for details.

You then need to build a query (where you link all the tables via relationships if you haven't done it in the Relationship window) and select all the tables you want to display on your report. Then you use this query as the Control Source for your Report.