query

[lcross]

i want to build a query that says:
in the col "properties" return all records that are between the word test.
1st record reads "test" and 34th record reads "test". so i want it to return the first 34 records.
i know there is a way but i just can't see it.

any help....

 

[neileg]

Order is not meaningful in a table so there are no tools in a query to identify the position of any given record. Is there anything in the data that identifies position, an autonumber for example? If there is, you perhaps can use DMin and DMax to find the values for your test records and use these as criteria. If there is more than one record with test as the significant field, this won't work!

You could do this in VBA by reading each record in turn to find the test records, but I can't help you with that.

 

[lcross]

i have autonumber but i dont see how it helps, cause i have the test word in more then 600 records .
what i need is a code to loop the records and see that record 1 is "test" then records until 57 are not, but record 58 is "test" after are not but i want it to give me a variable with all records between 1 and 57.
hope this isn't too confusing, i can't even think strait