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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In article <ewrhZSHtFHA.3500@xxxxxxxxxxxxxxxxxxxx>,
bamoob@xxxxxxxxxxxxxxxxxx says...
> 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" <roystont5038@xxxxxxxxxxxx> wrote in message
> news:MPG.1d8a3eaf8a6ecce989690@xxxxxxxxxxxxxxxxxxxxxxxxxx
> > 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.
.

Relevant Pages