Query needs to loop?

Is this possible?
A char variable length field contains this data: (for example)
ABC,XYZ,GEF,CAB
I need to query another table on the contents of each of these names that
are separated by comma.
I need to read ABC and then query another table for ABC in field1 and pick
up some fields.
Then, I need to do the same for XYZ, etc, reading across.
How can I parse the field that's comma delim, and in one continuous select
statment pick all the data from another table? Put a looping statement into
the Select statement to read through the comma delim field until done?
Thanks,
Don

.

Relevant Pages

  • Re: Query needs to loop?
    ... >I need to read ABC and then query another table for ABC in field1 and pick ... >How can I parse the field that's comma delim, ... Put a looping statement into ...
    (microsoft.public.sqlserver.mseq)
  • Re: Order By - Using abs formula in 2003
    ... RecordSource property to the name of the query. ... and Size of the TranAmount field. ... >>> ABC -6.55 ...
    (microsoft.public.access.forms)
  • Re: Help with Crosstab Query to transpose data
    ... SQL from the menu in query design... ... ABC 01-Jan-1980 $2.10 ... ACE 01-Jan-1980 $12.40 ... I want to write a crosstab query that will transpose (to use an Excel ...
    (microsoft.public.access.queries)
  • Re: Exporting query with duplicates
    ... Just set up a report on the query, group on ID or name, force each group to start on a new page and add the fixed text around the report data controls... ... ABC Co. ... XYZ Inc. 4545 ... for each 'ID' with a 'subform' of sorts on each form that will list all ...
    (microsoft.public.access.externaldata)
  • Re: Change of field name causes application to crash
    ... I created a simple Sum query against the underlying ... AS ArriveNet, SumAS ABC ... FROM LookupInventoryCombinedNet ... But if the yes/no field comes from a table that is on the outer side ...
    (microsoft.public.access.modulesdaovba)