Issue with Query data

[andrewchap]

So I am creating a movie database for my movies. I have field that has the names of the lead cast (3 most popular). These names are in the same field box. When I run a query to search for all the movies a particular actor is in, I come up empty.

How can I fix this?

Thanks in advance.



P.S. I tried to add pictures but it wont let me.

[June7]

Is the field a multi-value type? Are you using a multi-select combobox to enter values? Advise not to use multi-value fields.

Fix it by normalizing data structure. Have a related table that has a record for each person.

There are numerous threads dealing with movie database.

[andrewchap]

I tried multi-value and combobox but with no luck. I'm pretty new to access so it could be operator error.


I just want to be able to put the actors in the same field box as shown below and then run a query to search what movies are associated with a particular actor.

I've ran the query using only one name in each field box successfully so I'm assuming the query isn't completing correctly because there is more than one name.


Is there a way to correct this?

[June7]

I already advised correction in previous post.

Or learn what a multi-value field is and how to use. https://support.office.com/en-us/art...#bkmk_criteria