lookup and calculations between 2 queries??

[jonnywakey]

Hi All

Wondering if anyone can offer a solution to the following, may be simple but I'm struggling with this one!

I have 2 queries 1 called [Prod Performance]
the second query is called [Shifts]

Field within [Prod Perf] which I want to use is called [Prod Date] & [Hrs]

Field within [Shifts] which I want to use is called [Shift Date] & [Shift Total]

I need a query to compare dates which match from both queries and then divide [Shift total] / [Hrs] to give a number.

Hope this is clear enough for someone to help!

Thanks

Jonny

 

[jdraw]

Jonny,

Can you post a jpg of your relationships window? You'll have to zip it before posting.