Query from Field

M

markmidwest

I have a simple database with a user code & a line of
information specific to that user code. I would like to
create a query where the code has to be entered & then it
only shows that 1 line of information.

I know this must be simple but I'm drawing a complete
blank.

Any help would be appreciated.

Thanks,
Mark
 
J

John Spencer (MVP)

Simplest method is a parameter query. In the query grid, do something like the following.

Field: [User code]
Criteria: [Which user code?]
 
Top