Results 1 to 2 of 2
Thread: Query Help (2003)
2008-04-03, 17:48 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Query Help (2003)
This may not be possible but I thought I would give it a try. I have a query that has a field Client Id. The next field is Login ID. A Client Id can have Multiple Login IDs. They can have from 2 to 10 Log in Ids. Now there are 4 fields at the end of the query that contain Xs for each Login ID. If the Xs (in the 4 fields) are alike for every log in id for a Client then I want a field that says "Yes". If any one of the Log in Ids for the Client Id is different from the rest, I want a "N" . Any help you can provide is much appreciated.
2008-04-03, 17:59 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Query Help (2003)
Create a query based on the table/query.
Add the ClientID field and the 4 fields with Xs to the query grid (but no other fields).
Set the Unique Values property of the query to Yes.
Save this query as (for example qryUniqueXs.
This query returns the unique combinations of Xs for each client.
Create a new query based on qryUniqueXs.
Select View | Total to make it a totals query
Add the ClientID field to the query grid.
Create a calculated field in the first empty column:
Set the Total option for this column to Expression.
This query will show the Yes/No value for each client.