Inter Table calculations

[michaelhare]

I have a master table that looks up data in an employee table and a customer table. The customer table has fields used to calculate items in the master table. I have been able to design a report that displays all of the appropriate data from the sub tables and that is working well. The problem I'm having is using sub table data to calculate items in the master. Can anyone let me know what I need to do to get what I need. Here are the fields I'm using (these are just test tables so I can learn how to do this in a regular db).

Transactions	Employee	Pricing
Transaction	Employee ID (1)	Customer ID (2)
Employee [Look-up (1)]	Last Name	A
Pricing [Look-up (2)]	Address	B
		C
		D

In a report using the Transactions Table I want to use the values in Pricing (A), (B), (C) & (D) to calculate a total in the report. I can't seem to be able to add these values.

Please help.

[June7]

A B C D are fields? Why can't you add them? What have you tried? What happens - error message, wrong results, nothing?

Have you built a query that joins the tables?

[michaelhare]

yes ABC&D are Fields. I named them that just as a test so I can apply the technique to another db. When I try to create a field in my report to add the values I can't access the fields. I will try to build a query and let you know.

Thanks

[michaelhare]

I finally got the fields to show and I was able to build an expression to add them. When I view the report I get "#TYPE" But all of the fields are formatted as currency.

[June7]

Did you put the expression in ControlSource property?