Comparing & Finding Non-Duplicates

[Vylent Fyre]

Hi everyone.

I'm trying to do what I think is probably not too complex but I cannot wrap
my brain around the logic behind it.

In one table, I have Month Booked, Division, and Vehicle #. What I want it
to do is to compare each Vehicle #'s for Current Month (05/2008) to last
month (04/2008) and bring over the differences in the Divisions. For example:

Month Booked Division Vehicle #
04/2008 01 00985
05/2008 02 00985
04/2008 10 01010
05/2008 10 01010

It should show me the Vehicle # 00985 for the month of 04/2008 and 05/2008
since the Divisions do not match. I should not see Vehicle # 01010 because
the Divisions do match from this month and last month.

What do I need to do to do this?

 

[Jeff Boyce]

One approach might be to create several queries.

One would get all of last month's info. Another would get all of this
month's info.

A third would use the Unmatched Query wizard to find entries in the first
query not in the second.

A fourth would use the ... to find entries in the second not in the first.

I'm sure there's a more elegant way (I believe it's called a "frustrated
outer join")...

Good luck!


Regards

Jeff Boyce
Microsoft Office/Access MVP