what function do I use?

  • Thread starter Thread starter Randadtb
  • Start date Start date
R

Randadtb

Ok, I have one unbound form with an unbound text field
named strNumber that receives a string of up to 33 digits
typed in, and a table with a column name possiblematch
that has 24000 records of 9 digits (datatype=text,
noduplicates, unique_values).

Ex: Data entered in the strNumber unbound field of the
form is = 8888888881231231237777
and in the table I have a record that is = 123123123

How can I select the record 123123123 through a query?

Thank you in advance.
 
It would really help if you provided the names of the
pertinent controls.

If you want to select every record that might be related
to your 9-33 character string, including 812312312,
881231231, and 123123123, then your query needs to look
something like:

SELECT * FROM yourTable
WHERE instr(me.textField, [YourTable].[PossibleMatch]) > 0

HTH
Dale
 
make query1 with the columns of Strnumber table + add 1column:
mid([strNumber];10;9)
make query2 with query1, joined on the second table - join the new column
(above) of query 1 to the 123123123-column of your table.
this way, you select the record with 123123123
 
Hello Dale,
Thought the names would be irrelevant since I said the objects and thank you for the light...wont forget it..

Best regards

Randal

Dale Fye said:
It would really help if you provided the names of the
pertinent controls.

If you want to select every record that might be related
to your 9-33 character string, including 812312312,
881231231, and 123123123, then your query needs to look
something like:

SELECT * FROM yourTable
WHERE instr(me.textField, [YourTable].[PossibleMatch]) > 0

HTH
Dale
-----Original Message-----
Ok, I have one unbound form with an unbound text field
named strNumber that receives a string of up to 33 digits
typed in, and a table with a column name possiblematch
that has 24000 records of 9 digits (datatype=text,
noduplicates, unique_values).

Ex: Data entered in the strNumber unbound field of the
form is = 8888888881231231237777
and in the table I have a record that is = 123123123

How can I select the record 123123123 through a query?

Thank you in advance.

.
Click to expand...
Click to expand...
 
Hi Genius,
Thank you for your imput, I really appreciate the your enlightment.
Best
Randal

Genius Maximus said:
make query1 with the columns of Strnumber table + add 1column:
mid([strNumber];10;9)
make query2 with query1, joined on the second table - join the new column
(above) of query 1 to the 123123123-column of your table.
this way, you select the record with 123123123


Randadtb said:
Ok, I have one unbound form with an unbound text field
named strNumber that receives a string of up to 33 digits
typed in, and a table with a column name possiblematch
that has 24000 records of 9 digits (datatype=text,
noduplicates, unique_values).

Ex: Data entered in the strNumber unbound field of the
form is = 8888888881231231237777
and in the table I have a record that is = 123123123

How can I select the record 123123123 through a query?

Thank you in advance.
Click to expand...
Click to expand...
 
Back
Top