I need a report of just one actor's movies in Video Collection.-please help.

[Royston]

Hi,

I want to make a data base of my video collection such that I can find
just the movies made by a particular actor.

I have made the mdb file using the Wizard, and have the ID, the actor
name, actress name, etc. tabularised. I have then, using wizards, been
able to create a report of all the movies made by each actor covering
all the actors and all the movies in the mdb file.

What I really want is to be able to type in the name 'Jane Doe', and get
a list of only the movies made by her, plus the ID number, so that I can
readily get the tape out of the box where it is stored according to the
above ID number.

Will you please tell me how to do this.

Many thanks
Royston.

 

[BruceM]

Perhaps you made the table using the wizard? The table would be an Object
in the mdb file, but you need to be in the file in the first place before
you can use the wizard.
Have you made the report? If so, does it provide a listing of all
performers in your database? If it works OK for displaying all records, I
will assume that its record source is a table. Make a query from the table.
In query design view, in the Criteria box in the PerformerName column, enter
=[Performer Name]. Switch to database view for the query. You will see the
same box if you open a form or report based on the query. See Parameter
Query in Help for more information.
A few words about the name in the query. You have provided few details
about your database, so I don't know if you have separate fields for
FirstName and LastName. If you do, and if you would rather search by full
name, at the top of an empty column in query design view enter FullName:
[FirstName] & " " & [LastName]. Use your actual field names rather than
what I have used. This will be the column in which you can enter
=[Performer Name].

 

[Royston]

Perhaps you made the table using the wizard? The table would be an Object
in the mdb file, but you need to be in the file in the first place before
you can use the wizard.
Have you made the report? If so, does it provide a listing of all
performers in your database? If it works OK for displaying all records, I
will assume that its record source is a table. Make a query from the table.
In query design view, in the Criteria box in the PerformerName column, enter
=[Performer Name]. Switch to database view for the query. You will see the
same box if you open a form or report based on the query. See Parameter
Query in Help for more information.
A few words about the name in the query. You have provided few details
about your database, so I don't know if you have separate fields for
FirstName and LastName. If you do, and if you would rather search by full
name, at the top of an empty column in query design view enter FullName:
[FirstName] & " " & [LastName]. Use your actual field names rather than
what I have used. This will be the column in which you can enter
=[Performer Name].

Hi,

I want to make a data base of my video collection such that I can find
just the movies made by a particular actor.

I have made the mdb file using the Wizard, and have the ID, the actor
name, actress name, etc. tabularised. I have then, using wizards, been
able to create a report of all the movies made by each actor covering
all the actors and all the movies in the mdb file.

What I really want is to be able to type in the name 'Jane Doe', and get
a list of only the movies made by her, plus the ID number, so that I can
readily get the tape out of the box where it is stored according to the
above ID number.

Will you please tell me how to do this.

Many thanks
Royston.

BruceM Hi, and thank you for your response. This is just a holding
message. I will do my best to follow the steps you have suggested and
will report back the progress. Please return here to follow up.

Many thanks
Royston.

 

[Royston]

Perhaps you made the table using the wizard? The table would be an Object
in the mdb file, but you need to be in the file in the first place before
you can use the wizard.
Have you made the report? If so, does it provide a listing of all
performers in your database? If it works OK for displaying all records, I
will assume that its record source is a table. Make a query from the table.
In query design view, in the Criteria box in the PerformerName column, enter
=[Performer Name]. Switch to database view for the query. You will see the
same box if you open a form or report based on the query. See Parameter
Query in Help for more information.
A few words about the name in the query. You have provided few details
about your database, so I don't know if you have separate fields for
FirstName and LastName. If you do, and if you would rather search by full
name, at the top of an empty column in query design view enter FullName:
[FirstName] & " " & [LastName]. Use your actual field names rather than
what I have used. This will be the column in which you can enter
=[Performer Name].

Hi,

I want to make a data base of my video collection such that I can find
just the movies made by a particular actor.

I have made the mdb file using the Wizard, and have the ID, the actor
name, actress name, etc. tabularised. I have then, using wizards, been
able to create a report of all the movies made by each actor covering
all the actors and all the movies in the mdb file.

What I really want is to be able to type in the name 'Jane Doe', and get
a list of only the movies made by her, plus the ID number, so that I can
readily get the tape out of the box where it is stored according to the
above ID number.

Will you please tell me how to do this.

Many thanks
Royston.

BruceM Hi, and thank you for your response. This is just a holding
message. I will do my best to follow the steps you have suggested and
will report back the progress. Please return here to follow up.

Many thanks
Royston.

BruceM hello again,

It works. Thank you.

Out of curiosity, I clicked on SQL View and found something like this
((([video collection].Actor)="John Doe"));
Will you please point me to where I can find some explanation or guide
as to the meaning of these punctuation marks and how to use them in
Access? I would guess that it is some kind of programming language.

Royston.