MS Access query help

[SilverHood]

Doing a query in access... I've done this 100 times at college, but can't remember the exact command.

Under criteria, I want the user to enter an email address, which then finds the associated username.

Any help would be appreciated.

 

[SilverHood]

nm, sorted it out.