Finding records with same criteria

  • Thread starter Thread starter Emmy
  • Start date Start date
E

Emmy

I want to bring up all records for a certain client. For instance, all
clients named "Smith". I'm used to working with Microsoft Works database.
That allowed me to bring up a group of records, and then choose "all records"
to get back where I started. Can anyone help do that with Access?
 
Exactly how depend upon your version, but generally, you can:

1. Write a query which prompts for the name.
2. Use QueryBySelection which allows you to right-click in a text box and
type in criteria.
3. Use QueryByForm, from the menu which allows you to turn your form into a
criteria engine.
 
Thank you. I did realized I didn't include that I'm working with 2007, but
too late.
after reading your reply, I was able to get what I wanted.
Emmy
Office 2007
 
Back
Top