Search results for query: *

Actually, you know what? This query will sometimes return too many rows. If one of the movies in the search criteria contains two actors that are also in a third together, it will also return that movie. For example, I ran 'Seven' and 'American History X' and got back 'Outbreak' because Morgan...

Absolutely perfect. I just had to change 'on M2.ActorID = S2.ActorID' to 'on M2.MovieID = S2.MovieID'. Probably just a typo. Thanks a million.

I can't seem to wrap my mind around this query. I'm not sure if it's even possible. I have a personal Movie Database and I'm trying to write an SQL Query which will do the following: When given two different movie titles, I would like the query to find a third movie title (if it exists) that...

Works perfectly.

Sure, here's my two queries: First: 'OnlyComputerAnimation' (to isolate computer animation movies SELECT Movies.MovieID, Movies.Title FROM Genres INNER JOIN (Movies INNER JOIN lnkGenres ON Movies.MovieID=lnkGenres.MovieID) ON Genres.GenreID=lnkGenres.GenreID WHERE Genres.Genre="Computer...

Hello, I've got a personal movie database I'm finishing up with and I can't figure out how to query across multiple linked tables (I'm self taught). Here's what I want to know: List all movies in the database that are computer animation, but are NOT Pixar. Here's the relevant table...

PHV, I tried your code again and it did work. I don't know what I was thinking. Thanks. Also, instead of using my long code in the beginning, I just used the Subform's recordset object. My problem was not putting ".form" after my subform name. Go figure.

Thanks PHV. I tried your correct syntax, but it still didn't work. I suppose I'll content myself with calling the procedure in the subform. I'm running Access 2003 on Windows XP Pro if that makes any difference. Any thoughts on my other question?

Ladies and gentlemen: I have a form with a continuous subform linked to it which contains two controls, side by side. What I would like for Access to do is to not display any scroll bars on the subform unless the subform contains over 8 records linked to the particular record the main form is...

Specifically what I'm looking for is this: I need for a field in a table that will order each row sequentially at the user's whim each time a new record is input. For example, there is a hundred rows in the table. The field I need would have these rows ordered from one to one hundred, with no...