Query from Field

  • Thread starter Thread starter markmidwest
  • Start date Start date
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
 
Simplest method is a parameter query. In the query grid, do something like the following.

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