selection query

  • Thread starter Thread starter siemon
  • Start date Start date
S

siemon

I want to make a selection of the main table with a sub table.
For so far I've got the criteria: [SubTable]![Subjects]

This only works for identical fields, so my question:

is it possible to make a selection of all the fields in the main table
that CONTAINS (startswith, endswith or in the middle) the text in the
sub table.

Thanks,
Siemon
 
siemon said:
I want to make a selection of the main table with a sub table.
For so far I've got the criteria: [SubTable]![Subjects]

This only works for identical fields, so my question:

is it possible to make a selection of all the fields in the main table
that CONTAINS (startswith, endswith or in the middle) the text in the
sub table.
Click to expand...


Either you're looking something out of the ordinary or I
just understand what you want here. Please provide a copy
of your query along with a few example records from both
tables and an explanation of what results you're looking for
from the example data.
 
Back
Top