Creating queries in Access 2000

[DAVID_PARENT]

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!

 

[Steve Schapel]

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],"*")