Re: query to combine values if true

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

the query i need is just for one instance of display.
the table is designed to match exactly a data entry form.
once the data is collected it is analyzed by epidemiologists who use SAS.
they insist upon flattened data.
i am open to suggestions of a better design.
once again - i inherited the existing backend, but i have leeway to makes
things better if the end product is not hampered.


"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in message
news:O26sKnu$IHA.4536@xxxxxxxxxxxxxxxxxxxxxxx
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: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Update with like * criteria
    ... Non-equi join is a join where the on clause is other than field equals field. ... You MIGHT get this to display in design view and it might work with a cartesian query. ...
    (microsoft.public.access.queries)
  • Re: Query Design View is Slow to Open
    ... same query takes about 20 minutes to open in datasheet view. ... took only seconds to open in both design view and datasheet view. ... The troublesome queries are based entirely on local tables (i.e. no ... HOUSEHOLD_PersonalInfo opens slowly in design ...
    (comp.databases.ms-access)
  • Re: Is this join valid?
    ... > complex set of tables and queries, but I've boiled down the behavior ... you describe a problem with the Design View that really should not ... affect what happens when running a query from ASP. ... > the SQL view after creating the query in Design View. ...
    (microsoft.public.inetserver.asp.db)
  • Re: query to combine values if true
    ... What if you keep your data tables in a well-normalized form (to help Access ... you can give them a form and a way to query and they'd be ... i am open to suggestions of a better design. ...
    (microsoft.public.access.gettingstarted)