Video Collection report difficulty, please help.

[Royston]

Hi,

I am a total beginner to Access.

I want to make a database of my extensive video collection, such that I
can simply enter the name of an actor, and the software will produce a
list of all the movies he appeared in, and the ID of the video, (so that
I can retrieve it from the box it is kept in along with a hundred
others).

I first used the Wizard to make a mdb file. It shows the ID number, name
of movie, actor name, actress name, and a few other details of the
movie. Fine.

I next found that I had to make a Query, so I used the Wizard to do
that. The query includes actor name, movie title and ID. Fine.

Next I used the Wizard to create a Report, and to group according to
actor name, showing the movie title and ID. Fine.

The report then lists all the actors in my collection, and the movies
they have appeared in. Whereas I want only the movies made by one
particular actor. I want to be able to, say, type in the actor name
'John Doe' and retrieve only the movies made by John Doe.

Will you please tell me how I can do this?

Many thanks,

Royston.

 

[Chris Reveille]

I would create a form with the field Actor in it.
In your report query put the following in the criteria for actor.
like "*"&[forms]![formname]![Actor]&"*"
Add a command button to the form that generates the report

 

[Duane Hookom]

Martin Green has some good tutorials on how to do this at
http://www.fontstuff.com/access/index.htm

 

[Royston]

Martin Green has some good tutorials on how to do this at
http://www.fontstuff.com/access/index.htm

Thanks, but which particular tutorial should I study. There are many on
that web page.

Royston.

 

[Duane Hookom]

It wouldn't hurt to scan through them all to find the ones that apply.

 

[Royston]

It wouldn't hurt to scan through them all to find the ones that apply.

I thought that you might say that. OK. It does seem a lot to trawl
through, though.

Royston.

 

[Royston]

I would create a form with the field Actor in it.
In your report query put the following in the criteria for actor.
like "*"&[forms]![formname]![Actor]&"*"
Add a command button to the form that generates the report

Chris Reveille Hello, thank you for your response. At first I was not
able to understand your advice. The inverted commas, asterisks, and
brackets had me puzzled, as I did not know what they represented. Now I
know that what you suggested is a good guide as to what I had to do.

I got what I needed by going into Design View, creating a query table,
then in the criteria box entering the name of the actor I need. Changing
to Database View then revealed the list I want. Out of curiosity I
clicked on SQL View, and thus arrived at a rendering of various
punctuation marks.

Could you please point me to where I can learn about the significance of
these punctuation marks relevant to Access?

Thank you

Royston