looking up specific records

  • Thread starter Thread starter holstein
  • Start date Start date
H

holstein

I have an Access 2002 database that I store test scores
in. I've created a query to display name and test score.
How can I set this query up so it will allow me to enter
a name and display only that name and score? I hope I
explained this correctly. Any help would be appreciated.
Thanks in advance.
 
A parameter query will help.

Select ScoreName, Score from tblScore
Where ScoreName = [Enter Name]

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
-----Original Message-----
I have an Access 2002 database that I store test scores
in. I've created a query to display name and test score.
How can I set this query up so it will allow me to enter
a name and display only that name and score? I hope I
explained this correctly. Any help would be appreciated.
Thanks in advance.
.
Click to expand...
You need to make this into a parameter query. All you have
to do is type "[Name]" (without the quotes") in the
criteria row under the column that is headed with name
field from the table. This is done in design view of the
query.

When you run the query, you will be prompted for the name
and after you enter a name exactly the way it is in the
table, you will get that record only displayed with
whatever other fields are in the query. If there are
fields you do not wish to display, uncheck the boxes in
the "Show" row under the fields you do not wish to display.

Hope this helps.
 
Thank you very much. It worked just like I want it to.
-----Original Message-----
A parameter query will help.

Select ScoreName, Score from tblScore
Where ScoreName = [Enter Name]

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

holstein said:
I have an Access 2002 database that I store test scores
in. I've created a query to display name and test score.
How can I set this query up so it will allow me to enter
a name and display only that name and score? I hope I
explained this correctly. Any help would be appreciated.
Thanks in advance.
Click to expand...


.
Click to expand...
 
Back
Top