Divide query

[dzepeda]

Hi

I have two querys:

qry1: (Multiple records)
ProductName
TotalFixCost


qry2: (only total: 1 record)
TotalUnitsProduced

I need to determine the fix cost of each product:

TotalFixCost(Each Product)/TotalUnitsProduced

Here is the problem: there's not relationship between the tables and when I put together no record is selected.

any idea?

 

[dzepeda]

Problem Solved:

Query was Ok. One parameter of Qry1 was missing.