e.g. - Record track called "We wish you a Merry Xmas" - I wish to type in
e.g. "Merry" and query searches all tracks on database for matches ?!
If you have different fields for each track, you can put a criterion
LIKE "*" & [Enter search term:] & "*"
under each track field, on *different* rows in the query grid to use
OR logic so it will find the record regardless of which field it's in.
If it is, you also should redesign your table; you're using a
relational database, and you should use it as designed: you have a one
(CD) to many (track) relationship, and would do better to use two
tables in a one to many relationship, with *one* field for the track
title.
John W. Vinson[MVP]
