Parameter Query

  • Thread starter Thread starter tR
  • Start date Start date
T

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
 
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.
 
Back
Top