Parameter Query

[tR]

In my table (Notes), each note can have three different
Topics Fields (Topic1, Topic2, Topic3). The three
fields are all based on the tame table (Topics). How
can I get my Parameter Query to check all three fields
(examaple: If I have a topic "Cures", it could appear in
any one of the three fields, but I want the query to list
all the notes in which "Cures" appears in one of them.

tR

 

[Van T. Dinh]

Your Table is NOT normalised. You should normalise the Table to get the
best from Access.

In the mean time, you can use something like:

SELECT *
FROM Notes
WHERE (Topic1 = [Enter topic:])
OR (Topic2 = [Enter topic:])
OR (Topic3 = [Enter topic:])

Make sure the 3 instances of the parameter have exactly the same spelling.