Re: Multiple field query

Sounds like you have not normalized your data. If the value could be in any
of the 20 fields, that tells me that these fields are not unique. It is a
One-to-many relationship. You should have a table that contains the ID and
the OPERATION only. If a particular ID has one operation, it would have one
entry in the table. If a particular ID has ten operations, it would have
ten records in the table. Etc.


--
Rick B



"EdS" <EdS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A83146FA-350F-4583-B224-09F0B44A9B66@xxxxxxxxxxxxxxxx
> I have a table with one id field and 20 operation fields. The operation
> fields are text, into which the user has made various entries. Each id
may
> have values in one or more of the twenty operation fields.
>
> I need a query that will give me single column list produced from all 20
of
> the opeation fields (over the whole table). My need is to get unique list
of
> all operations entered into the table. Any help??
>
> --
> Thanks. EdS


.

Relevant Pages

  • Multiple field query
    ... have values in one or more of the twenty operation fields. ... I need a query that will give me single column list produced from all 20 of ... EdS ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Identifying fields out of order
    ... Click on "Create Query in Design View" ... tblSeq AS Prev, tblSeq AS Next; ... Our SQL now would look like: ...
    (microsoft.public.access.queries)
  • Query based on Column Index
    ... I have attached the sql to a query that I have developed. ... regarding the TraitHistory fields. ... Prev fields from my table and update the query. ... query determine the Curr and Prev based on their position in the table. ...
    (microsoft.public.access.queries)
  • Re: data on CD (was New RISC OS Application)
    ... Assuming the data was on some large relational database machine, ... quite easy for a SQL practitioner to write a query to select part of it. ... Was EOS (EDS?) on the make? ...
    (comp.sys.acorn.apps)
  • RE: Basic Question- "IIF/Like"
    ... I've created a corresponding query that in the conditions field ... > query works correctly by returning all records but if the user types a ... Prev by Date: ...
    (microsoft.public.access.queries)