Calculating data from two different tables

[robk5787]

Hey folks,
I have a table with several data fields in it, but the most important benig the cost for each seperate row. I am trying to compare that data with another table that holds my plan costs for the data fields in the first table. Does anyone know how to create a query or report that will allow me to show the real costs compared to the planned cost. I would like to generate some type of report from this, but I really would like to fiigure out how the query works. Thanks in advance for any help!

 

[dcx693]

This is a very basic query. Create a query where you include both tables. Ideally, each table will have an identifier field that is unique to each row. Join the tables on that field. Choose the fields that you wish to display by dragging them from the tables down to the query grid.

Look in the Access online help for more info on creating queries.

 

[Mile-O]

Be more specific when talking about the tables. You haven't mentioned what fields they have, what keys link them, etc.