Simple Question

[gold2040]

Hey

This is probably an extremley simple question but say for example you had a query which had a list of people in with their name, address, age eg:

How would you make it so you can input the name john and it would come up with just the age for example of all the people called John

This is Access 97

Cheers

Tom Evans

 

[gromit]

See the attached example. There is a query called qryParameterNameAge that allows you to enter a name and will display matching records. Note that the name must match exactly.

The query shows both name and age. If you want age only, then go to design view and uncheck the "Show" box under Name.

-g