Microsoft Access - Enter Parameter Value why?
- by Jane Doe
I am encountering a problem for my database.
Here is the relationships of the database
And tried to do the query for how many transactions have movie "Harry_Potter"?
so I used SQL query:
SELECT
COUNT(td.movie) AS number_of_occurrence,
td.transaction_number
FROM
TransactionDetails td,
MovieDetails md
WHERE
md.movie = Harry_Potter
But it asks…