John Jason Jordan wrote:
I have a field I use for selecting records in a database of test
questions by placing unique strings in the field. For example, I might
enter "FE1a-001" which means that it will be merged into Final Exam 1a
and will be question #1. This works well, but sometimes I need to merge
the same question into other documents. For example, if I want the same
question to appear in Final Exam 3c as question #30 I need to enter
"FE3c-030" in this field as well.
I can add both values in the field, but then the select queries do not
pick up the record at all. I need the LIKE operator to function as long
as the string occurs *anywhere* in the field, not that the field be
*the same as* the string.
I tried adding a new field, but Base informed me that if I did so it
would delete all the data in the table!
I need to get the project delivered to the customer by Monday morning
so I'm getting desperate for a solution. The Help file has nothing
about how the syntax is supposed to work. Are there other operators
besides LIKE? If so, what are they, and how do they work?
John:
I created a test database table with an ID field, a Test Number field,
and a Question field.
| ID | Test | Question |
| 0 |FE1a-001 | Question 1 |
| 1 |FE3c-030 | Question 2 |
| 2 |FE1a-001 FE3c-030 | Question 3 |
I then created a query in design mode. In the Criterion row under Test
I entered LIKE '*FE3c-030*' and ran the query. The result was
| ID | Test | Question |
| 1 |FE3c-030 | Question 2 |
| 2 |FE1a-001 FE3c-030 | Question 3 |
Isn't that what you want to happen? I am using version 3.2.1 on an XP
machine.
Gene Kohlenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
