Wish to set up a parameter query searching multiple fields

[Guest]

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 ?!

 

[Guest]

You need to use the like operator in your criteria with wild cards:

Like("*" & [prompt or a reference to a form] & "*")

 

[John Vinson]

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]