Creating queries in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a application written in Acccess 2000 that does incident tracking for
a technical help desk. One of the issues I have with the database is the
need to search for particular incidents by date, subject, submitter, etc. I
think the way to do this is to create a query for each of the fields I'd like
to search. So far, I haven't had much success. Any suggestions on how to
accomplish this task would be appreciated. Thanks!
 
David,

One approach to this is to make an unbound form with some unbound
textboxes or (more likely for subject and submitter) comboboxes, where
the user can enter the criteria required. Then, in the Criteria of the
query, refer to the controls on the form, using syntax such as...
Like Nz([Forms]![NameOfForm]![NameOfControl],"*")
 
Back
Top