matching data

[eiao]

I have two lists of data 1)plan 2) actual. Based on 3 categories
(date,location and cage number), i want to compare "plan" and "actual"- rows
in the two data-sets. If a match is found between two rows, then return these
rows and calculate the deviation, thus making a plan vs actual-report. What
type of formula or macro can do this?

 

[Tom van Stiphout]

On Thu, 13 Dec 2007 05:41:01 -0800, eiao

Imagine if you had a single table with:
date, location, cagenumber, plan, actual

That's a better design, and one of the benefits is that the query now
is trivial.

-Tom.