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 <MPG.1d8cc6d9217eb60f989691@xxxxxxxxxxxxxxxxxxxxxxx>,
roystont5038@xxxxxxxxxxxx says...
> 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.
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.
.

Relevant Pages