Return "yes" or "no" if value in one field matches any value i

Return "yes" or "no" if value in one field matches any value i

Post by ZGF0YWR5b » Wed, 15 Oct 2008 01:40:01


Is there a way to do what you suggested through the Design View? I'm rather
new at this.
 
 
 

Return "yes" or "no" if value in one field matches any value i

Post by ZGF0YWR5b » Wed, 15 Oct 2008 02:05:01

I just tried what you suggested and still came up with duplicate data,
however this time, I received all "Yes" values even for state and county
combinations that were NOT assigned to this builder. See below.


Bldr Job_ST Job_CO Assigned_CO_Shipment
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 82 Yes
2265 43 87 Yes
2265 47 20 Yes
2265 47 20 Yes
2265 47 35 Yes

In this example, for Bldr=2265, their only assigned state and county
combinations are:

Assigned_ST=43 and Assigned_CO=46
Assigned_ST=43 and Assigned_CO=82

So I should be getting "Yes" for all records below EXCEPT for the last three
that are to state and county combinations that are NOT assigned to this
builder.

Any ideas?

 
 
 

Return "yes" or "no" if value in one field matches any value i

Post by Marshall B » Wed, 15 Oct 2008 08:14:15


I don't see(?) anything wrong with my suggested query.
Please post a Copy/Paste of the query you used.

--
Marsh
MVP [MS Access]
 
 
 

Return "yes" or "no" if value in one field matches any value i

Post by John Spenc » Wed, 15 Oct 2008 08:33:23

Marshall,

I believe you need to join on one more field bldr to get the desired result.

I posted that earlier, but have not heard back if my posting solved the
problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================