Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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:

    Alike: IIf(Count(*)=1,"Yes","No")

    Set the Total option for this column to Expression.
    This query will show the Yes/No value for each client.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts