Re: query to combine values if true

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave has provided a way to work with what you've described.

Would you care to elaborate on why the table structure is immutable? Folks
may be able to offer alternate approaches if they understood better the
constraints you are facing...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"mcnewsxp" <mcourter@xxxxxxxxxxxxxx> wrote in message
news:O6TCPIu$IHA.984@xxxxxxxxxxxxxxxxxxxxxxx
i have a table that contains yes/no fields for race. in my query i what
only one column for race. an inividual may be multi-racial. so i need a
query to combine all of the yes/no field checked true. i will come up with
some abbreviations so the column need not be rediculously wide.
can someone point me in the right direction for the query?
BTW - changing the table structure in not an option.
tia,
mcnewsxp



.

Relevant Pages

  • Re: Expression Not or Not Like
    ... would you care to elaborate on your question? ... I tried to run the query. ... Thats not the right result. ...
    (comp.databases.ms-access)
  • Re: Compare two tables and write results to third table
    ... users and understand tables and records and queries and code. ... combine an Append query and an Update query as one. ... "Jeff Boyce" wrote: ... The new list can have folks who moved, it can have new folks and where they ...
    (microsoft.public.access.queries)
  • Re: Linking form information to specific tables
    ... Some folks get it, some folks don't ... ... like have a query pull only the records that have an "A" in the Type ... and then use the Form Builder wizard to ... A wizard will appear asking you pertinent questions. ...
    (microsoft.public.access.gettingstarted)
  • Re: Building Complex Criteria for Queries in Access 2007 (Part II)
    ... normalization/relational database design ... ... use of tools like Word and Excel is relatively easy because most folks work ... Please post the SQL statement your query uses. ... is that in teh current form, if teh user would like to see all Categories ...
    (microsoft.public.access.queries)
  • Re: LDAP query question
    ... First off, user isn't an objectcategory, it is an objectclass. ... You will want something like ) to specify users. ... Benefit Admin)(!department=Managed Care Consulting)) ...
    (microsoft.public.windows.server.active_directory)